Good afternoon,
I am building a VLookup formula that is to perform a different VLookup calculation, depending upon a selection box in another cell.
I want the first argument to look up C11. If C11 = 'NEW', then perform a certain VLookup calc.
If it is anything other than 'NEW', then perform another VLookup calculation.
Currently it works fine when NEW is selected, but when anything else is selected, it reports back as FALSE in my cell.
Not sure what I'm doing wrong. Any advice?
=IF(C11="NEW",IFNA(VLOOKUP($A11,'SHEET'!1:$238,51,FALSE),IFNA(VLOOKUP($A11,'SHEET'!1:$238,63,FALSE),"")))
Thank you.
I am building a VLookup formula that is to perform a different VLookup calculation, depending upon a selection box in another cell.
I want the first argument to look up C11. If C11 = 'NEW', then perform a certain VLookup calc.
If it is anything other than 'NEW', then perform another VLookup calculation.
Currently it works fine when NEW is selected, but when anything else is selected, it reports back as FALSE in my cell.
Not sure what I'm doing wrong. Any advice?
=IF(C11="NEW",IFNA(VLOOKUP($A11,'SHEET'!1:$238,51,FALSE),IFNA(VLOOKUP($A11,'SHEET'!1:$238,63,FALSE),"")))
Thank you.