Forum Discussion
Solved
Nesting VLOOKUP, IF and AND
Hi, I have a large spreadsheet of data. Column A is names (with multiple duplicates), Column F is a data value, and Column E is a data value, and Column D is a data value. I have copied my list of ...
=INDEX($D$3:$D$13,MATCH(1,(A3:A13=H3)*(F3:F13="TR1")*(E3:E13=1),0))You can try INDEX and MATCH which seems to work in my sheet.
=INDEX($D$3:$D$13,MATCH(1,(A3:A13=H3)*(F3:F13="TR1")*(E3:E13=1),0))You can try INDEX and MATCH which seems to work in my sheet.
- That is perfect. Thank you so much.
You are welcome.
=VLOOKUP(H3&"TR1"&1,CHOOSE({1,2},$A$3:$A$13&$F$3:$F$13&$E$3:$E$13,$D$3:$D$13),2,0)With VLOOKUP you can try the above formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
