Vlookup or If statement Help

J

JPriest

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
 
J

JPriest

Mr.Shorty,

It makes sense, however when I make the changes, I get a #REF!. Shee
1, Col A contains a constant text and Sheet1 Col B contains the Code.
am using Vlookup to search Sheet2 ColA for the constant from Sheet1 Co
A and extracting the correlating data from Sheet2 ColB into Sheet
ColB.

Here is the formula I'm currently using:
=VLOOKUP(A1,Sheet2!A1:A100,2,FALSE)

As a side note, when I change the col Index from 2 to 1 I get the valu
of Sheet2 Col A in Sheet1 Col B.

Hope you can help me out with this,
Jef
 
J

JPriest

Greg,
I made your suggested changes and now I get an #N/A error!

Any thoughts?

Jeff
 
M

MrShorty

From Excel (2002) help > If lookup_value is smaller than the smallest value in the first colum
 
J

JPriest

When I select "Help on this error' and then 'step in', i get the messag
that 'cell currently being evaluated contains a constant'.

What I'm trying to do is automate a web report after I get th
information from a web query. I want to automatically scan the we
query for a specific web link in one col and place the correlating hit
from the cell beside it into the report.

the formula i have been trying is the one above, but to no avail.

Please help!!

Jef
 
Top