Code: Select all
=HLOOKUP(OR(F1,G1,H1,I1),G3:O4,2,TRUE)Multiple HLookUp
-
JoeExcelHelp
- 5StarLounger
- Posts: 1177
- Joined: 22 Jul 2013, 18:29
Multiple HLookUp
Is it possible to apply a HLookUp with multiple references and return the first value I desire in this case F1 ? such as:
-
HansV
- Administrator
- Posts: 78412
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multiple HLookUp
As an array formula, confirmed with Ctrl+Shift+Enter:
=INDEX(G4:O4,MATCH(0,ISERROR(MATCH(F1:I1,G3:O3,0))*COLUMN(F1:I1),0))
=INDEX(G4:O4,MATCH(0,ISERROR(MATCH(F1:I1,G3:O3,0))*COLUMN(F1:I1),0))
Best wishes,
Hans
Hans