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
Bookmarks