I have 2 tabs and I want to get the information from TAB2 to TAB1. I want to get the RETAIL Price from TAB2 and place it in TAB1. The condition to get the correct price is that it should be based on the ITEM CODE and SIZE of the item from TAB1 and get the same from TAB2.

Here's a demo Sheet: https://docs.google.com/spreadsheets/d/1CFTYCokv7teHVYDZOPquj1r0n7ZTQV3XYqrCM-EPLAk/edit?usp=sharing

1 Answer 1


One way to do that is to use a compound key in a lookup formula like this:

=arrayformula( iferror( vlookup( A3:A & B3:B, { F3:F & G3:G, I3:I }, 2, false ) ) )

Place the formula in cell D3 in your sample spreadsheet.

To use the formula in your real spreadsheet, modify the range references like this:

=arrayformula( iferror( vlookup( A3:A & B3:B, { 'Items list'!A2:A & 'Items list'!B2:B, 'Items list'!D2:D }, 2, false ) ) )

The bit in curly braces is an { array expression }.

  • Ok, I will try that as soon as I get home. Thanks! Jun 13, 2021 at 6:42
  • You got it, thank you very much! One less problem to worry. Jun 13, 2021 at 9:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.