Forum Discussion

techyaccountant's avatar
techyaccountant
Copper Contributor
May 07, 2024

Help with double cell lookup formula

I am trying to pull a value based on one worksheet data into another, essentially being a vlookup based on ID but also with the condition it matches an item name.

Example:

I want to find the value of C3 and D3 from column H and I by looking at both A3 and B3. I cannot seem to figure out the extra condition/formula to use with a traditional vlookup since I am doing it based on two conditions. 

 

 

Resources