Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table lookup
Hi Everyone,
I am trying to do a simply lookup table, but its been years since i have done it and can't remember. i want the excel to give me a dropdown of tariffs and it fills in the customer price adn company GP? it sounds simple but i can not get it working. Thanks in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table lookup
have a table with tariffs price and GP
Do a Data - Validation using the tariffs as your drop-down in your cell to the right =VLOOKUP(Tariff cell,Table range,2,0) and the same further right except =VLOOKUP(Tariff cell,Table range,3,0) Can make it nicer if you include an IF =IF(ISNA(VLOOKUP(Tariff cell,Table range,2,0)),"",VLOOKUP(Tariff cell,Table range,2,0)) to show a null vlaue if the VLOOKUP is blank. "Richard" wrote: Hi Everyone, I am trying to do a simply lookup table, but its been years since i have done it and can't remember. i want the excel to give me a dropdown of tariffs and it fills in the customer price adn company GP? it sounds simple but i can not get it working. Thanks in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table lookup
See these:
How to setup a lookup table: http://contextures.com/xlFunctions02.html How to setup a drop down list: http://contextures.com/xlVideos07.html#DataVal01 -- Biff Microsoft Excel MVP "Richard" <Richard @discussions.microsoft.com wrote in message ... Hi Everyone, I am trying to do a simply lookup table, but its been years since i have done it and can't remember. i want the excel to give me a dropdown of tariffs and it fills in the customer price adn company GP? it sounds simple but i can not get it working. Thanks in advance |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Table lookup
If you are looking to create a drop down list to choose from select the cell
or cells where the validation needs to take place. Go to Data - Vaidation - Settings. Change Allow to List and then select the list you wannt to use "T. Valko" wrote: See these: How to setup a lookup table: http://contextures.com/xlFunctions02.html How to setup a drop down list: http://contextures.com/xlVideos07.html#DataVal01 -- Biff Microsoft Excel MVP "Richard" <Richard @discussions.microsoft.com wrote in message ... Hi Everyone, I am trying to do a simply lookup table, but its been years since i have done it and can't remember. i want the excel to give me a dropdown of tariffs and it fills in the customer price adn company GP? it sounds simple but i can not get it working. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup data in a variable table & retrieve data from a pivot table | Excel Worksheet Functions | |||
table lookup | Excel Discussion (Misc queries) | |||
Lookup Table help | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) | |||
lookup or table, not sure what to do | Excel Worksheet Functions |