Vlookup functions

[iamsvs]

i know basic use of vlookup.

but i need is .

This is Sheet1

A B

arun 101

bala 102

raja 103

this type.

what i'm ask means.

i have sheet2 only number for column A

this is sheet2

A B

101

102

103

i need name for b column.

using vlookup.

Not change column A for Sheet1

[JBeaucaire]

Vlookup doesn't read right to left, it reads left to right, so you need something else.

As long as the codes in column B are IN ORDER ascending, a simple LOOKUP will do the trick, but any out of order codes will result in an error.

=LOOKUP(A1,Sheet1!B1:B3,Sheet1!A1:A3)

[Trebor76]

Hi there,

Welcome to the forum.

Assuming your dataset starts at row 2 - row 1 being for headings (change as required) the following left lookup on Sheet2 will do the trick (regardless of the order):

=OFFSET(Sheet1!$B$2,MATCH(A2,Sheet1!$B$2:$B$4,0)-1,-1,1,1)

HTH

Robert

[royUK]

Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.