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 ...
I'm guessing you have other data manually entered in Spreadsheet B and that is why you can use a pivot table or power query (but actually this might still be an option)? If you must use a lookup you can combine criteria inside the xlookup something like the following. but note I don't see where the event is located in spreadsheet B. Also, this can easily be an array so a) I will assume the classes and events are an array of values in columns C4:.C99 and D4:.D99 but that the rider number is unique to that sheet (C2). So in G4 would be:
=XLOOKUP(C4.C99 & $C$2 & D4:.D99, SheetA!H1:.H999 & SheetA!A1:.A999 & SheetA!C1:.C999, SheetA!G1:.G99, "")