Thread: Multiply values make up a cell answer

Hello,

I have a problem I'm not sure if the way I phrase it will be confusing but here goes,

I want to be able to use a text value and an numerical value from another function to create a cell value.

So for example
=IF(A14="Not Enough Stock Available",VLOOKUP(D14,Stock_Table1,4,FALSE),"")

But where you see the vlookup part, I want to be able to add a comment after of the value which will be "in stock".

So it will be like "28 in stock", where the number 28 will be the number that I gain from the vlookup.

I was wondering if an AND function would work but I can't get it to.

Thanks in advance to anyone who can contribute

Hi,

Use concatenation :

VLOOKUP(D14,Stock_Table1,4,FALSE)&" in stock")

HTH

thanks ya'll ,

You don't know how happy I am, consider it solved, nd thanks for the quick reply

I feel so stupid it was that simple. lol