MrExcel Publishing
Your One Stop for Excel Tips & Solutions

=VLOOKUP


Posted by Keith on January 10, 2002 11:43 AM

I imported a query in excel and it works fine. I named the imported data: DATA4. Then I used the =VLOOKUP formula to lookup corrisponding data when a user types in the id number. The name, email address, and phone are displayed in the cells with the =VLOOKUP formula. I was wondering if there is a way I could maually type in and update the data in one of these cells without erasing the =VLOOKUP formula. Thank You for all your help so far Mark.


Posted by Jacob on January 10, 2002 12:00 PM

Hi

you can change the data all you want the vlookup will still work fine.

HTH

Jacob

Posted by Keith on January 10, 2002 12:59 PM

Hello

Jacob---- this doesn't seem to work ----

I trying to add on to the data in the same cell as the vlookup formula without erasing the formula and replacing it with the data I manually type in. When I type in the same cell as the formula and then go to a different cell the formula is replaced with the data I typed in the cell.

Thank you for your help.

Posted by Chris D on January 10, 2002 1:22 PM

do you mean adding something onto the end of the result ?

ie "Chris added this"

rather than just type it in, edit the cell formula by adding &"Chris added this" to the end of it.

It will look something like :

=VLOOKUP(D19,A16:C25,3,FALSE)&"Chris added this"

and give a result something like this :

Company A Chris added this

If you want to add a formatted number rather than that "Chris" text, just include the TEXT function :

=VLOOKUP(D19,A16:C25,3,FALSE)&TEXT(2567.8,"#,###.00")

which will give a result something like this :

Company A 2,567.80

Hope this helps
Chris


Posted by Chris D on January 10, 2002 1:26 PM

Keith, you're not trying to add little comments or reminders are you ? You know about the "add a comment" function, right ?!

Posted by Jacob on January 10, 2002 1:53 PM

Oh

You cant change the formula itself you can change the data in the columns that the vlookup is checking.

Jacob

Posted by Keith on January 11, 2002 5:20 AM


No, sometimes the VLOOKUP doesnt return a value in the cell and the #NA appears instead, and I would like to add data maunally if vlookup doesn't find a record without erasing the formula.

like you stated in the relpy before the & character will work fine when I want to addition info to the cell besides the data retreived by vlookup.

Thank you for all your help guys.