Forum Discussion
Solved
Hlookup multiple criteria and rows help please
Hello, I want to auto populate a cell based on the info below. If some one types in : A01 I want the cell to say ARPT Example 2: If someone types I04 I want to the cell to say INFL ...
Hi John,
For such location
it'll be
=IFERROR(INDEX($B$2:$J$2,SUMPRODUCT(($B$3:$J$42=$M$2)*COLUMN($B$3:$J$42))-COLUMN($B$2)+1),"no such")
Please see attached.
Hi John,
For such location
it'll be
=IFERROR(INDEX($B$2:$J$2,SUMPRODUCT(($B$3:$J$42=$M$2)*COLUMN($B$3:$J$42))-COLUMN($B$2)+1),"no such")
Please see attached.
Thank You , This worked out.
John Sokolowski , you are welcome
