Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm trying to match my selection from a dropdown list to a row, and then my
selection from a different drop down list to the column that matches it, so I can retrieve the cell that both the column and row match up to... Similiar to a times table. My best shot is: =IF(B4=0," ",VLOOKUP(B4,FixType!$A$1:$V$58,(HLOOKUP(C4,FixTyp e!$A$1:$V$58,1,FALSE)))) But it only *sometimes* returns a number from the FixType worksheet, and it's either wrong or #VALUE. Thanks, PC |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
Combine Vlookup and Hlookup | Excel Worksheet Functions | |||
Can I nest Max in 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 |