V look up

  • Thread starter Thread starter EF
  • Start date Start date
E

EF

How do you use the vlookup to look up information on two different
spreadsheets? Could you answer this question on a step-by-step basis please.
Someone took me through it but I got confused with the explanation.
 
See if this helps:

Sheet1

...........A..........B
1........x.........north
2........y.........east
3........z.........south

Sheet2

A1 = lookup value = y

B1 = lookup formula:

=VLOOKUP(A1,Sheet1!A$1:B$3,2,0)

Result = east
 

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

Microsoft Excel - Looking up values from a range by selection by scroll of arrow keys. 1
Outlook email 3
V-Look Up 5
VLOOKUP 4
v look up and rounding 2
Speech Recognition & Dictation in Excel: How to turn it on? 0
V Look Up 5
I'm back ! 18

Back
Top