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