Hi,
I have trawled through all the questions on vlookup but cant seem to find an answer similar to what I'm trying to achieve.
Here goes
I'm looking up a cell which will either hold a value or be blank, if the cell holds a value I want to output a 4 (not the value in the cell) but if it is blank I need to output blank.
=IF(VLOOKUP(E2,staffdata!B:K,10,FALSE),4,"") this works where there is a value but I get #VALUE if the cell is blank.
Im sure this is a simple fix but my brain has shut down.
Thanks lots
Claire
I have trawled through all the questions on vlookup but cant seem to find an answer similar to what I'm trying to achieve.
Here goes
I'm looking up a cell which will either hold a value or be blank, if the cell holds a value I want to output a 4 (not the value in the cell) but if it is blank I need to output blank.
=IF(VLOOKUP(E2,staffdata!B:K,10,FALSE),4,"") this works where there is a value but I get #VALUE if the cell is blank.
Im sure this is a simple fix but my brain has shut down.
Thanks lots
Claire