Forum Discussion
Solved
IF and VLOOKUP works and then stops
Hi, I'm not an excel expert so forgive me if this is a silly question or I'm approaching it all wrong. I want to pull metric 1 from a range named 'METRIC' only if B2 is the same as a...
=VLOOKUP(A2&B2,CHOOSE({1,2},Tabelle2!$A$2:$A$7&Tabelle2!$T$2:$T$7,Tabelle2!$S$2:$S$7),2,0)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=INDEX(Tabelle2!$S$2:$S$7,MATCH(1,INDEX((A2=Tabelle2!$A$2:$A$7)*(Tabelle1!B2=Tabelle2!$T$2:$T$7),0),0))An alternative could be INDEX and MATCH.
=VLOOKUP(A2&B2,CHOOSE({1,2},Tabelle2!$A$2:$A$7&Tabelle2!$T$2:$T$7,Tabelle2!$S$2:$S$7),2,0)You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=INDEX(Tabelle2!$S$2:$S$7,MATCH(1,INDEX((A2=Tabelle2!$A$2:$A$7)*(Tabelle1!B2=Tabelle2!$T$2:$T$7),0),0))An alternative could be INDEX and MATCH.
OliverScheurichThe first option worked. Thank you so so much I've a new skill for life now 🙂
