View Single Post
 
Old 08-26-2014, 05:07 PM
excelledsoftware excelledsoftware is offline Windows 7 64bit Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

No problem ask away.

so you would change the vlookup on your first sheet to include all of the searchstring. Based off of the example you provided the formula would be something like
Code:
=VLOOKUP(A9&B9&"_"&E9&" "&F9,'Data Scrape'!C:O,13,0)
You need to get the first part of the vlookup to equal what the search string is. Once you get it to work you shouldnt need to update it again and when you run the script it will pull in this new formula. If that dosnt quite make sense PM me and well get it all sorted out.

Thanks
Reply With Quote