I need to create an IF statement that will;

Search all of row C: C: on worksheet 3 for a number that matches cell Y on
worksheet 1

Then pull the content of cell Z on sheet 3 and display it in a cell
designated on the same column as Cell Y

OR

Better yet using the SQL tool in Excel how can I merge 2 querys results
from 2 different databases combine the matching results then display them

Unfortunately there are 2 DBs that I require data from in which I need to
match the result list of both querys and include the relevant data. I can
match the data by the same part numbers that exist in both DBs


Thanks in advance
--
Neall

You don't say which cell in column Y on sheet 1 so this assumes Y1
Put this on sheet 3
=VLOOKUP(Sheet1!Y1,Sheet3!C1:Z1000,24)

Mike


"Neall" wrote:

I need to create an IF statement that will;

Search all of row C: C: on worksheet 3 for a number that matches cell Y on
worksheet 1

Then pull the content of cell Z on sheet 3 and display it in a cell
designated on the same column as Cell Y

OR

Better yet using the SQL tool in Excel how can I merge 2 querys results
from 2 different databases combine the matching results then display them

Unfortunately there are 2 DBs that I require data from in which I need to
match the result list of both querys and include the relevant data. I can
match the data by the same part numbers that exist in both DBs


Thanks in advance
--
Neall

Thanks seemed to of done the trick, one more questions, for the results that
dont have a value I am getting #NA how do I get rid of that?


--
Neall


"Mike H" wrote:

You don't say which cell in column Y on sheet 1 so this assumes Y1
Put this on sheet 3
=VLOOKUP(Sheet1!Y1,Sheet3!C1:Z1000,24)

Mike


"Neall" wrote:

I need to create an IF statement that will;

Search all of row C: C: on worksheet 3 for a number that matches cell Y on
worksheet 1

Then pull the content of cell Z on sheet 3 and display it in a cell
designated on the same column as Cell Y

OR

Better yet using the SQL tool in Excel how can I merge 2 querys results
from 2 different databases combine the matching results then display them

Unfortunately there are 2 DBs that I require data from in which I need to
match the result list of both querys and include the relevant data. I can
match the data by the same part numbers that exist in both DBs


Thanks in advance
--
Neall