| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Table lookup
Ive a currency table with historical exchange rates for the year.
The months, Jan, Feb, Mar€¦. are column labels and the currencies CZK, DKK, EUR, HUF€¦(sorted) are row labels and the different monthly exchange rate in the intersections. Id like to find the rate for EUR in April but VLOOKUP or HLOOKUP only gives me a REF error. It seems that it doesnt accept other that 1, 2 ,3, 4€¦. as column labels in Vlookup or as row labels in HLookup. Strange, I think Ive played with these two ones before and it worked OK. |
| 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 please | 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 | |||
Threaded Mode
