D daxeman New Member Sep 5, 2022 #1 Hi, I need some help in doing a excel lookup that obtains a value using multiple criteria's across different columns. Appreciate any help I can get (excel data attached) Thank you. Doug Attachments data.xlsx data.xlsx 129.9 KB · Views: 8
Hi, I need some help in doing a excel lookup that obtains a value using multiple criteria's across different columns. Appreciate any help I can get (excel data attached) Thank you. Doug
ETAF Active Member Sep 5, 2022 #2 try a grid lookup =INDEX($B$3:$G$187,MATCH(I4,$A$3:$A$187,0),MATCH(K4,$B$2:$G$2,0)) Attachments data-ETAF.xlsx data-ETAF.xlsx 130.1 KB · Views: 11
D daxeman New Member Sep 5, 2022 #3 ETAF said: try a grid lookup =INDEX($B$3:$G$187,MATCH(I4,$A$3:$A$187,0),MATCH(K4,$B$2:$G$2,0)) Click to expand... Thank you @ETAF this is exactly what I needed!!!
ETAF said: try a grid lookup =INDEX($B$3:$G$187,MATCH(I4,$A$3:$A$187,0),MATCH(K4,$B$2:$G$2,0)) Click to expand... Thank you @ETAF this is exactly what I needed!!!
