 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / September 2005Vlookup
Can you base a vlookup formula on data that has been concatenated? Yes. Would you like to describe what you're trying to do, so that you can get a more helpful answer? > Can you base a vlookup formula on data that has been concatenated? On the destination sheet I have a column that has first and last names that have been joined by concantenating them. On the reference sheet, the cells contain the same first and last name (the matching column) but they have been exported from a system and did not need to be concatenated. I know that the vlookup formula is correct because if I type over the concatenated cell the actual first and last name, It will then reference the student number (The infomration that I am trying to bring over to the destination sheet.) So I guess my uqestion is how do I make data that has been concatenated into text. > Yes. > > Would you like to describe what you're trying to do, so that you can get a > more helpful answer? > > > Can you base a vlookup formula on data that has been concatenated? if your lookup range contains Row# ColA ColB 1 Name Student# 2 Carey, Duke 897 3 Doe, Lisa 1022 and you have the text Doe in cell C6 and the text Lisa in D6,use =VLOOKUP(C6&", "&D6,A2:B3,2,0) > On the destination sheet I have a column that has first and last names that > have been joined by concantenating them. On the reference sheet, the cells [quoted text clipped - 12 lines] > > > > > Can you base a vlookup formula on data that has been concatenated? I didn't think about essentially doing both operations in one. That is a great idea! Thank you! Lisa > if your lookup range contains > [quoted text clipped - 23 lines] > > > > > > > Can you base a vlookup formula on data that has been concatenated? The other thing you might check, if you've imported your data from another source, is that you don't have "hidden" leading or trailing spaces. That can really screw up your conatenation (and therefore your VLOOKUP)... > On the destination sheet I have a column that has first and last names that > have been joined by concantenating them. On the reference sheet, the cells [quoted text clipped - 12 lines] > > > > > Can you base a vlookup formula on data that has been concatenated? Thank you for your help! It now works beautifully! > The other thing you might check, if you've imported your data from another > source, is that you don't have "hidden" leading or trailing spaces. That can [quoted text clipped - 16 lines] > > > > > > > Can you base a vlookup formula on data that has been concatenated? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.