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

=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

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

Posted on Aug 07, 2009

Please show practicly use of VLOOKUP

Posted on Feb 25, 2013

How to convert excel file into openoffice?

Posted on Jul 01, 2010

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

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

E.g

Jun 25, 2009 | Microsoft Excel for PC

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/

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

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.

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

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

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

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

=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

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.

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.

Oct 10, 2007 | Microsoft Office Standard for PC

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

Jan 28, 2016 | Microsoft Excel for PC

4,736 people viewed this question

Usually answered in minutes!

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

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

×