| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Multiple lookup values in =HLOOKUP
A classical formula might be =HLOOKUP(a1,a100:z100,1,FALSE). But I want to
display the result if the lookup value = a1 or a2 or a3 or...a10 ie: anything in the range a1.a10, without writing a multiple nested statement. Any ideas? Thanks. -- Peter London, UK |
|
#2
|
|||
|
|||
|
Try...
=INDEX(A1:A10,MATCH(TRUE,INDEX(COUNTIF(A100:Z100,A 1:A10)0,0),0)) ....confirmed with just ENTER, or... =INDEX(A1:A10,MATCH(TRUE,COUNTIF(A100:Z100,A1:A10) 0,0)) ....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Hope this helps! In article , "Peter" wrote: A classical formula might be =HLOOKUP(a1,a100:z100,1,FALSE). But I want to display the result if the lookup value = a1 or a2 or a3 or...a10 ie: anything in the range a1.a10, without writing a multiple nested statement. Any ideas? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Cell Values, please help | Excel Discussion (Misc queries) | |||
| Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
| Using SumIF formulas with multiple lookup values | Excel Worksheet Functions | |||
| Footer values on multiple worksheets | Excel Discussion (Misc queries) | |||
| Multiple X-Axis Values | Charts and Charting in Excel | |||
Linear Mode
