Lookup

  • Thread starter RE: VLOOKUP fORMULA
  • Start date
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
 
S

Stefi

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

„RE: VLOOKUP fORMULA†ezt írta:
 
J

Jacob Skaria

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

If this post helps click Yes
 
B

brett

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 criteria lookup of text. Return text form column 3. SUMPRODUCT t 2
Four criteria MATCH INDEX lookup of date between matching two text 9
Lookup question 6
Need help with ISNA, INDEX, MATCH 2
Need help with DGET function 7
V-/H- LOOKUP still confusing 3
Lookup with wrong result values 7
lookup function bringing in wrong info 8

Top