vlookup help plz

O

owls_amy

I need to create a vlookup formula.
it ivoles 2 sheets
here is the question
in sell j5 use the vlookup function to play appropriate description for the
order. use the book id as the lookup value . The look up table is the table
named description in the lookup table worksheet. the column index number is
2 and the range_lookup value is false

thanks amy
 
S

Stephen Lloyd

Assuming the Book id is in j4, the workbook name is Tables, the lookup tables
range name is 'description' (change these to whatever you want), try the
following...

=VLOOKUP(j4,Tables!description,2,False)
 
B

Bob Phillips

You've done it all

=VLOOKUP(B5,description,2,FALSE)

which assumes that column B is the bookid

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 

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

Top