Vlookup or If statement Help

  • Thread starter Thread starter JPriest
  • Start date Start date
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
 
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
 
Greg,
I made your suggested changes and now I get an #N/A error!

Any thoughts?

Jeff
 
From Excel (2002) help > If lookup_value is smaller than the smallest value in the first colum
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if then statement (i think) or vlookup 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
LookUP function with multiple variables and worksheets 1
Trying to sum cells across different worksheets in different locat 4
Simple nested if and statement 2
producing a report via a keyword - filtering and macros not suitab 1
Match with 3 criteria 3
Trying to match 1 value to multiple columns 10

Back
Top