vlookup help plz

[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

 

[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)

 

[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)