Archive of Mr Excel Message Board


Back to Forms in Excel VBA archive index
Back to archive home

=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.

Check out our Excel Resources

Re: =VLOOKUP

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


Re: =VLOOKUP

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.


Re: =VLOOKUP

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



Re: =VLOOKUP

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 ?!

Re: =VLOOKUP

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


Re: =VLOOKUP

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.


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.