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

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)

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)

"owls_amy" wrote in message
...
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