Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF statement in excel
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If statement in excel | Excel Discussion (Misc queries) | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |