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 |
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 |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com