R
RE: VLOOKUP fORMULA
Any body pls help me.....?
Sheet1
A B C
Name Rank Company
Romeo Painter PWD
Patrick Carpenter ABC
Sheet2
D E F G H
Name Result.
Romeo PWD
On Sheet2 (H2)
How can I Lookup for Romeo from Sheet1(A1:A100) and place the corresponding
value on C
For example:-
On Sheet2
D2(Sheet2) – If I type Patrick how can I get a result on H2(Sheet2)ABC
Sheet1
A B C
Name Rank Company
Romeo Painter PWD
Patrick Carpenter ABC
Sheet2
D E F G H
Name Result.
Romeo PWD
On Sheet2 (H2)
How can I Lookup for Romeo from Sheet1(A1:A100) and place the corresponding
value on C
For example:-
On Sheet2
D2(Sheet2) – If I type Patrick how can I get a result on H2(Sheet2)ABC