Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup?
I have a cell, with a lookup table that I can't get the formula correct and
maybe I'm not even using the correct formula. Table contains: cell A B C bx 4 gal pail 10 lbs bag 25 kg ton 2000 ton I want to match the "ORDER FORM" cell c to look at the table (ALPHA PRODUCTS) and match the corresponding cell in A (above from Alpha Products), then display cell b (Alpha PRoducts) as the answer in ORDER FORM cell c. What do I need to use! Thanks, Annette |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup?
Sorry I not understand you but take a look here
For left lookups see http://www.cpearson.com/excel/lookups.htm#LeftLookup And Debra's site http://www.contextures.com/xlFunctions02.html -- Regards Ron de Bruin http://www.rondebruin.nl "Annette" wrote in message ... I have a cell, with a lookup table that I can't get the formula correct and maybe I'm not even using the correct formula. Table contains: cell A B C bx 4 gal pail 10 lbs bag 25 kg ton 2000 ton I want to match the "ORDER FORM" cell c to look at the table (ALPHA PRODUCTS) and match the corresponding cell in A (above from Alpha Products), then display cell b (Alpha PRoducts) as the answer in ORDER FORM cell c. What do I need to use! Thanks, Annette |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |