Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with a Lookup Formula
I am not sure if it shoudl be a Vlookup or Hlookup formula and I am not sure
how to procede. I have a 4 x 4 table that looks like this from A1:D4 USD EUR GBP USD 1.0 1.19 1.73 EUR 0.83 1.0 1.45 GBP 0.57 0.68 1.0 In cell G1 I have a cell where I enter USD or EUR or GBP In cell F12 I have a cell where I enter USD or EUR or GBP In cell G12 I enter a number. I need a formula for cell H12 that will multiply the cell in G12 times the correct cell in the pivot table based on G1 and F12. For example if G1=USD and F12=USD then G12 should be multiplied times B2. what I am trying to do is create a simple report that calculates an expense item in one currency to a report base currency. Thanks for any help provided. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
formula to lookup table in another Worksheet please | Excel Worksheet Functions | |||
How do I have a formula lookup a sheetname? | Excel Worksheet Functions |