Formula - vlookup

Von Pookie

MrExcel MVP

Joined

Feb 17, 2002

Messages

13,686

• Oct 20, 2005

• #2

For VLOOKUP to work, the value you are searching for needs to be in the left column of the table you are searching. It will not work if you are searching column B and trying to return a value to the left of it.

 

Upvote 0

R

Roses8

Active Member

Joined

Aug 4, 2005

Messages

348

• Oct 20, 2005

• #3

Hi, I changed that but its still not working.

 

Upvote 0

NBVC

Well-known Member

Joined

Aug 31, 2005

Messages

5,828

• Oct 20, 2005

• #4

Try changing the 1 to FALSE. Does that work?

 

Upvote 0

Aladin Akyurek

MrExcel MVP

Joined

Feb 14, 2002

Messages

85,210

• Oct 20, 2005

• #5

Roses8 said:

Hi, Im trying to do a vlookp but with wrong results.

look up the value in B2 and match in column B in sheet 2, if they match then take the name from Column A in the same row should be the result.

=VLOOKUP(B2,Sheet2!A:B,2,1)

Thanks.

Click to expand...

If Sheet2!A:B is sorted on column B in ascending order and maintained in that order...

=LOOKUP(B2,Sheet2!B:B,Sheet2!A:A)

If not sorted...

=INDEX(Sheet2!A:A,MATCH(B2,Sheet2!B:B,0))

 

Upvote 0

R

Roses8

Active Member

Joined

Aug 4, 2005

Messages

348

• Oct 20, 2005

• #6

Hey, Thank you that worked. I sorted the columns and the results are spot on!.

 

Upvote 0