I
Iriemon
I am trying to do a vlookup that looks for the value in the cells in column A
in my table. However, some of the cells in column A are blank. My lookup
table has a blank in the first column and a code value to be returned in the
4th column. When I try to do the lookup and it encounters a blank cell, I get
a #N/A result instead of the code.
Here is the formula I have now.
=VLOOKUP(A13,$F$3:$I$13,4,FALSE)
Or should I use this as an alternate formula:
=IF(A13='"","L",VLOOKUP(A13,$F$3:$I$13,4,FALSE))
The formula above works, but I would like to use just a vlookup.
Any way around this or should I just use the 2nd formula?
Thanks
in my table. However, some of the cells in column A are blank. My lookup
table has a blank in the first column and a code value to be returned in the
4th column. When I try to do the lookup and it encounters a blank cell, I get
a #N/A result instead of the code.
Here is the formula I have now.
=VLOOKUP(A13,$F$3:$I$13,4,FALSE)
Or should I use this as an alternate formula:
=IF(A13='"","L",VLOOKUP(A13,$F$3:$I$13,4,FALSE))
The formula above works, but I would like to use just a vlookup.
Any way around this or should I just use the 2nd formula?
Thanks