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 ...
In Spreadsheet A, I created a concatenated helper column in column H using =A2 & B2 & C2.
Then I used XLOOKUP in Spreadsheet B, either:
=XLOOKUP(A2 & B2 & C2, A!$H:$H, A!$G:$G, ,0)
or create same helper formula in sheet2 and use
=XLOOKUP(H2, A!$H:$H, A!$G:$G,,0)
Sheet1
Sheet with Xlookup