Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help plz
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help plz
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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup help plz
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |