Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookup or If statement Help
Hi all, I'm hoping you can help ease the work of my CTRL+COPY, CTRL+PASTE fingers. I have one worksheet that which I have to fill-in with data from the web. I have copied and cleaned the data into 2 columns in a separate worksheet. I would like to search worksheet #2, col B for data that matches workbook#1, col b, and insert the correlating data from worksheet#2 col A into workbook#1 col e. Right now I'm coping and pasting these words into a search function on the webpage and then coping the data from the webpage into the workbook and my fingers are hurtin! Thanks for your help in advance, Jeff -- JPriest ------------------------------------------------------------------------ JPriest's Profile: http://www.excelforum.com/member.php...o&userid=24695 View this thread: http://www.excelforum.com/showthread...hreadid=382636 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Vlookup of an if statement return | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
If/And statement; VLOOKUP? | Excel Worksheet Functions | |||
Extension of and IF & VLOOKUP statement | Excel Worksheet Functions |