Adding text to a vlookup cell

[Lee Coleman]

Can a cell be edited if the contents are the result of a vlookup function
and still keep the rseults? I have 2003 on an XP Pro PC. My formula is
=IF(A4<>"",VLOOKUP(A4,InvDetail!$A$2:$B$3000,2,FALSE),"")
I trying to create an availability list for our customers but need to add
comments to the end of some items. I know I can add another column but the
customers are used to the comment being after the item description and space
on the page is limited.
Thanks,
Lee Coleman

 

[JE McGimpsey]

If you're talking about entering comments manually, then you'd need to
concatenate them:

=IF(A4...) & " my comment here"

Of course, that's really the function of cell comments, but they won't
display the way your customers apparently want them to.

If your comments are to be automatic:

=IF(A4<>"",VLOOKUP(...) & " comment","")

If the comment varies based on A4 then

=IF(A4<>"",VLOOKUP(...) & " " & VLOOKUP(A4,Commenttable,2,FALSE),"")

where Commenttable is the table of possible comments.

etc.

 

[Lee Coleman]

I will try the 3rd suggestion as the comments will vary based on the status
of the plant. I wanted to be able to edit the contents afterwards (something
like 4" Begonia Red "from the vlookup" and then add a comment 'full bloom')
but I can see how this would be disasterous for Excel.
Thanks for replying quickly.
Lee Coleman