View Single Post
  #1   Report Post  
JPriest
 
Posts: n/a
Default 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