![]() |
|
#1
|
|||
|
|||
![]()
Ok here is my suggestion for what you are trying to do. Normally I would write a VBA script to do this but it is very possible to do with formulas as well.
1: I would change where you create the search name into column A on Sheet2. This makes it alot easier to use it for vlookups. You can still easily copy and paste new data in the sheet just start on Column B. 2: I would change your search name formula to the following Code:
=SUBSTITUTE(LEFT(C2,FIND(",",C2)-1)," ","") 3: Use the following Vlookup formula in Column I for Sheet1 Code:
=VLOOKUP(B4&A4,Sheet2!A:D,4,0) If this still isnt quite what you are looking for maybe we should look into writing you a VBA script that will do this task automatically. Let me know Thanks |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Newbie to excel for starters, needing to transfer info from sheet2 to universe sheet. | rogcar75 | Excel | 0 | 08-12-2014 07:21 AM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
split text files to worksheets (sheet1,sheet2,sheet3 soon sheet 25) | gsrikanth | Excel Programming | 1 | 03-22-2012 11:04 PM |
![]() |
Antares | Project | 1 | 12-14-2011 09:19 AM |
![]() |
KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |