ExcelBanter - how do I do an if then query in excel from 2 sheets?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I do an if then query in excel from 2 sheets? (https://www.excelbanter.com/excel-discussion-misc-queries/52124-how-do-i-do-if-then-query-excel-2-sheets.html)

Kerry

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

Anne Troy

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

All times are GMT +1. The time now is 10:06 AM.