Question about Microsoft Excel for PC

4 Answers

How to use vlookup in openoffice using different sheets

Have being facing problems using vlookup in openoffice while using different sheets. am looking for sample solution

Posted by on

  • Anonymous Mar 30, 2009

    have being facing problems using vlookup in openoffice while using different sheets

  • beeseearr May 11, 2010

    What kind of problems are you facing? Can you share some more details about your problem?

×

4 Answers

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Expert
  • 407 Answers

=VLOOKUP(A2;Sheet1.$A$3:D27;2;0)

The cell I created this formula in was Sheet 3 Cell C9 - to show the different sheets
A2 is the cell I want to look up
Sheet1.A3:D27 is the range of cells that contains the data I want to return, The first column relates directly to cell C9 is Sheet 3. I locked the first cell in my range as I wanted to apply the same formula across other cells hence the $
2 is the number of the column that has the data I want to return, I had a choice in this formula of 4 columns
0 is the value to complete the formula

Posted on May 12, 2009

  • Level 1:

    An expert who has achieved level 1.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Contributor
  • 1 Answer

How to use vlookup in openoffice using different sheets plz cn u hlp me.

Posted on Aug 07, 2009

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Please show practicly use of VLOOKUP

Posted on Feb 25, 2013

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

How to convert excel file into openoffice?

Posted on Jul 01, 2010

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to use vlookup in openoffice using multiple sheets


Hi Anonymous, I want to help you with your problem, but I need more information from you. Can you please add details in the comment box?
In general, VLookUp can be used to find a value within a range (that's organised vertically), and then return a corresponding value from an adjacent column.
If you can describe in a little more detail what you want to do, I'm sure we can figure out a way to get it done.
Regards,
Scott

Jun 03, 2014 | Microsoft Excel for PC

2 Answers

What is vlookup in ms excel


It is a function in excel that will look up to a value or data located in different sheet or in different cells. It is very helpful function to look for a bunch of data and compair and extract the exact information. syntax: =vlookup(lookup_value,table_array, col_index_num,[range_lookup])

Aug 27, 2010 | Computers & Internet

1 Answer

What is the use of vlookup in excel?


The VLOOKUP function is a handy one to know when you want Excel to lookup a value in one place and insert it in another. For example, let’s say you have a list of all of your customers on a sheet named “Accounts” and an invoice on another sheet named “Invoice”. When you type in their account number on the Invoice, you want Excel to fill in the name of the customer and their address (and this information is included for all customers on the Accounts sheet). A VLOOKUP will do this for you.

Here's a tutorial that will help:

http://www.timeatlas.com/mos/5_Minute_Tips/General/Learning_VLOOKUP_in_Excel/

Jun 12, 2009 | Microsoft Excel for PC

1 Answer

VLOOKUP FORMULA PROBLEM


VLOOKUP(A1,Sheet2A2:B20,2,FALSE)

The assumption here is A1 in Sheet 1 is the cell you want to reference, This cell can be pasted - Any problems let me know.

Jan 21, 2009 | Microsoft Excel for PC

1 Answer

Need to use the VLOOKUP formula for more then one column


You probably need to organise your pricelist sheet so that you only have 2 columns, product and price. If this doesn't fix you, please provide the syntax of your vlookup code.

Dec 10, 2008 | Microsoft Excel for PC

2 Answers

LOOK UP AND ALLOCATE


Hi,
Could you write the column names from both the sheets seprately, and one data eg. that you need. It would be easier to understand the problem.


Thanks
Proton

Oct 17, 2008 | Microsoft Excel for PC

1 Answer

Using Vlookup to copy data from another worksheet


=if(isblank(vlookup(Sheet1!A1,Sheet2!$A$1:$B$4,2,0)),"",vlookup(Sheet1!A1,Sheet2!$A$1:$B$4,2,0))

Sep 12, 2008 | Microsoft Excel for PC

1 Answer

Vlookup


You know, you really should have said it's an Excel problem, because it is; also your invoice and receipt numbers should probably be 10-12 digits long (yes, even if you do a mere 20 deals a year).

Add error checks and alerts to your spreadsheet, for starters; second, state the version etc. of the spreadsheet program you use, and how much memory is available on your system. VLookup often bombed or just gave the last result forever if it didn't have 130MB to play with. Other times it behaved if you ran certain initializations for it....

Mar 23, 2008 | Computers & Internet

3 Answers

About function


I love vlookup! Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B: Song# Title 123 Love Me Tender 234 Blue Suede Shoes 345 Dixie Another worksheet has song number and performer in Row 1, Cols A:B Song# Performer 123 Elvis Presley 234 Carl Perkins 456 Cher Notice there is NO performer for song number 345 in the 2nd worksheet. Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B) Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet. Help me out Mr. VLOOKUP. Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0) Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A. That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet. That is why I prefer VLOOKUP over LOOKUP. I have found this explaination of the VLOOKUP parameters helpful: 1. Needle (A2) 2. Haystack (Sheet2!A:B) 3. RELATIVE Col containing result (2) 4. Need DIRECT MATCH ONLY (0) Hope this helps. Let me know if you have any questions.

Aug 27, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

4,784 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18384 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...