if empty say empty, if not do this formula

[davso87]

Hi all,

Fairly new to the forum, however im learning excel at a fast rate.

Basically i need help in a "heatmap" im creating for work. We have pick locations in which we pick stock from (obviously).
now the heat map lists the location and how many are due to move from it.
how i have it is it looks at the location and looks at another worksheet and says howmany are going out for this. i can get it to do this.
what i cant get it to do is if no item is in location to say "free" or "empty", but if there is stock in there but demand to say "no demand"

Im probably making it sounds really complicated.

the current formula im using is this.

=IF(ISNA(VLOOKUP(B2,Despatches!A:B,2,FALSE)),"EMPTY",VLOOKUP(B2,Despatches!A:B,2))

i dont just want it to find n/a's and change them to "empty" i want it to say if the cell is blank then leave the result as blank.
I really hope im making sense, if not please let me know


Kind Regards

Adam

 

[Michael M]

Is this what you want

=IF(ISNA(VLOOKUP(B2,Despatches!A:B,2,FALSE)),"",VLOOKUP(B2,Despatches!A:B,2))

 

[davso87]

Thanks for your reply!
kind of, but before it does this i want it to look at "B2" and if its blank leave it blank, if not then do this formula

Adam

 

[davso87]

i think i may have solved it, i have put in :-
=IF(ISBLANK(B2),"empty",IF(ISNA(VLOOKUP(B2,Despatches!A:B,2,FALSE)),"no demand",VLOOKUP(B2,Despatches!A:B,2,FALSE)))

it appears to work, i just have to make sure!!

 

[Michael M]

Also...

=IF(B2="","empty",IF(ISNA(VLOOKUP(B2,Despatches!A:B,2,FALSE)),"no demand",VLOOKUP(B2,Despatches!A:B,2,FALSE)))