Hi,
I have data in Sheet1 range B5:C11 and in range F5:H11
I would like to have a VLOOKUP formula in range D5:D11 so that if in any row of range B5:C11 (eg. B5:C5) the two values contained in the two cells are found in range F5:H11, then we get as result the corresponding text found in column H.
In my example below we see that we have text "A" and "C" in range B5:C5 which is also contained in range F6:G6 for this reason we would expect value orange to appear in cell D5.
See also other example highlighted in yellow.
Basically whereas VLOOKUP looks for same value in two ranges to give a result, I would need TWO matching values in same row to give result.
How do I do that?
Thanks,
N.
Ps. Apologies for not using XL2BB but had issues downloading it
I have data in Sheet1 range B5:C11 and in range F5:H11
I would like to have a VLOOKUP formula in range D5:D11 so that if in any row of range B5:C11 (eg. B5:C5) the two values contained in the two cells are found in range F5:H11, then we get as result the corresponding text found in column H.
In my example below we see that we have text "A" and "C" in range B5:C5 which is also contained in range F6:G6 for this reason we would expect value orange to appear in cell D5.
See also other example highlighted in yellow.
Basically whereas VLOOKUP looks for same value in two ranges to give a result, I would need TWO matching values in same row to give result.
How do I do that?
Thanks,
N.
Ps. Apologies for not using XL2BB but had issues downloading it