| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do I do an if then query in excel from 2 sheets?
I have 2 sheets in excel... I need to do a query that says IF a number is
input into a cell (in a large array) in sheet two, THEN the name that corresponds in that row will be input into a cell in sheet one. ARGH PLEASE HELP!!! Thanks, KAM |
|
#2
|
|||
|
|||
|
how do I do an if then query in excel from 2 sheets?
You can use a vlookup.
Instructions: http://www.officearticles.com/excel/...soft_excel.htm Tutorial: http://www.officearticles.com/tutori...soft_excel.htm ************ Anne Troy www.OfficeArticles.com "Kerry" wrote in message ... I have 2 sheets in excel... I need to do a query that says IF a number is input into a cell (in a large array) in sheet two, THEN the name that corresponds in that row will be input into a cell in sheet one. ARGH PLEASE HELP!!! Thanks, KAM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Micosoft Query does not export result set to excel | Excel Worksheet Functions | |||
| excel should have a function to count sheets | Excel Worksheet Functions | |||
| How do I join two excel sheets? | Excel Discussion (Misc queries) | |||
| How to make one CSV file from two Excel sheets? | Excel Discussion (Misc queries) | |||
| need an advice in excel sheets.... | Excel Discussion (Misc queries) | |||
Linear Mode
