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 query’s 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 query’s and include the relevant data. I can
match the data by the same part numbers that exist in both DBs

Thanks in advance