Adding text to a vlookup cell

  • Thread starter Thread starter Lee Coleman
  • Start date Start date
L

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
 
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.
 
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
 
Back
Top