Lookup
 

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

Lookup
 

In H2 use the formula
VLOOKUP(D2,Sheet1!$A$100:$C$100,3,FALSE)
--
If this post helps click Yes
---------------
Jacob Skaria


" VLOOKUP fORMULA" wrote:

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

Lookup
 

=VLOOKUP(D2,Sheet1!A:C,3,FALSE)
Regards,
Stefi

€ž VLOOKUP fORMULA€� ezt Ã*rta:

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

Lookup
 

Try
In H2
=VLOOKUP(D2,Sheet1!$A$2:$C$100,3,FALSE)

If this post helps click Yes
---------------
Jacob Skaria


" VLOOKUP fORMULA" wrote:

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

Lookup
 

This has more to do with formatting a text string, but how do i format a
column that already has data in it using "=TEXT(A1,"@")"? This is the only
way i have gotten my vlookup to work. It doesn't work just right clicking
and formatting cells. please help. thanks.
brett



" VLOOKUP fORMULA" wrote:

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