| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
array formula with if and hlookup
trying to make an array formula to look in row 2 for "4" and return from row
3, if row 1 = "1" looking for the answer "d" row1: 1 1 2 1 1 row2: 7 5 4 4 6 row3: A B C D E trying {=IF(A1:E5=1,HLOOKUP(4,A2:E5,2,FALSE)," ")} hoping someone smarter than me can help bport jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this possible with excel ? | Excel Discussion (Misc queries) | |||
| Is there any way to use HLOOKUP in an array formula to return multiple matches? | Excel Worksheet Functions | |||
| HLookup? or an array function?? | Excel Worksheet Functions | |||
| How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
| formula using both vlookup & hlookup | Excel Worksheet Functions | |||
Threaded Mode
