Forum Discussion
Vlookup with If And statement
This one has me stumped but excel is awesome and I feel like this should be possible. Thank you in advance for any help! I'm not sure the best way to go about this, I'm thinking a vlookup with with ...
Use INDEX + MATCH with multiple criteria:
=IFERROR(INDEX('Sheet A'!$G:$G,MATCH(1,('Sheet A'!$H:$H=$C$4)*('Sheet A'!$A:$A=$C$2)*('Sheet A'!$C:$C=$C$6),0)),"")
This matches class, rider number, and event, then returns the time from column G. If no match is found, it returns blank.