Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2 Variables determing a lookup sheet to use
Afternoon
I have a tally sheet that has 3 variables that can be changed one is GEO and the other is pricing level and part number. Each geo (USA,CAN, UK, AP) has the same pricing sheet outline with the pricing level left to right (A1 - A10) the part numbers (A2 - A 40) with the pricing in between. I currently have a statement that goes to one single pricing sheet and gets the data that I need which is =IF(ISERROR(INDEX('Value Unit Prices'!C22:N41,MATCH(C29,'Value Unit Prices'!A22:A41,0),MATCH(IF(ISBLANK(leveloveride), Pricelevel,leveloveride),'Value Unit Prices'!D21:N21,0))*P29),"",(INDEX('Value Unit Prices'!C22:N41,MATCH(C29,'Value Unit Prices'!A22:A41,0),MATCH(IF(ISBLANK(leveloveride), Pricelevel,leveloveride),'Value Unit Prices'!D21:N21,0))*P29)) 'Value Unit Prices' is the current locked pricing sheet, this needs to be a variable depending on what GEO the customer is from But now I need to add the variable of GEOs as the pricing changes per geography and this needs to be reflected in the price. what would I have to add to this above syntax to include the ability to choose the GEO which would then pull the pricing information from the corresponding sheet (example USA, CAN, UK, AP)? Any help would be greatly appreciated -- Neall |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup with two variables | Excel Discussion (Misc queries) | |||
Lookup with two variables | Excel Discussion (Misc queries) | |||
Lookup with Variables | Excel Worksheet Functions | |||
Determing last (used) row in a sheet | Excel Programming | |||
lookup 2 variables | Excel Discussion (Misc queries) |