Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Vlookup and Hlookup
Hi,
I would like to do a lookup on a table by searching on the column and the line. Example : A1 = EUR A2 = 2w on another sheet, I have a table with on the first line : B1 C1 D1 E1 F1 1w / 2w / 3w / 4w / 5w on the first column A2 A3 A4 EUR / USD / JPY so the idea is two find the value which is at the intersection of the first line = A2 (ie 2w) and the first column = A1 (ie = EUR). Please can you help me on this? Thank you in advance, Serge |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine Vlookup and Hlookup
Try this:
=VLOOKUP(A1,Sheet2!A1:F4,MATCH(A2,Sheet2!A1:F1,0), 0) Biff "serge" wrote in message ... Hi, I would like to do a lookup on a table by searching on the column and the line. Example : A1 = EUR A2 = 2w on another sheet, I have a table with on the first line : B1 C1 D1 E1 F1 1w / 2w / 3w / 4w / 5w on the first column A2 A3 A4 EUR / USD / JPY so the idea is two find the value which is at the intersection of the first line = A2 (ie 2w) and the first column = A1 (ie = EUR). Please can you help me on this? Thank you in advance, Serge |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
VLOOKUP & HLOOKUP | Excel Worksheet Functions | |||
Do I need to combine hlookup and countif????? | Excel Worksheet Functions | |||
HLookup, IF statement, multiple sort, somehow combine all of these | Excel Worksheet Functions | |||
Vlookup and Hlookup | Excel Worksheet Functions |