dustinshepard
New Member
If I have a VLOOKUP setup however sometimes the value is custom and is not in the VLOOKUP, then use the value as entered.
ie:
If the vlookup is looking at Sheet1!B2 for the value and the value in Sheet1!B2 is "1234" which is not in the VLOOKUP then I would like to use the value of "1234". Here is what the VLOOKUP I have looks like of course if the value is not in the list now then I get a 0
=IF(Sheet1!B2<>"", VLOOKUP(Sheet1!B2, Sheet2!A:B, 2, FALSE), "")
Thank you in advance for your help with this!
ie:
If the vlookup is looking at Sheet1!B2 for the value and the value in Sheet1!B2 is "1234" which is not in the VLOOKUP then I would like to use the value of "1234". Here is what the VLOOKUP I have looks like of course if the value is not in the list now then I get a 0
=IF(Sheet1!B2<>"", VLOOKUP(Sheet1!B2, Sheet2!A:B, 2, FALSE), "")
Thank you in advance for your help with this!