lookup and if?
I have 2 sheets ... I need to do a query that says IF a number is
input into a cell (in a large array ie c1:z26) in sheet two , THEN the name that corresponds in that row(a1:a26) will be input into a certain cell in sheet one (aa1:zz52). The columns dont match up.. ARGH PLEASE HELP!!! Thanks, KAM |
lookup and if?
First of all, "zz52" is not a valid cell reference in Excel. "IV" is column
256, which is the maximum available column. For the first part of your question, here is code to iterate through the input range and find the correct text from column A: Code:
Option Explicit "Kerry" wrote: I have 2 sheets ... I need to do a query that says IF a number is input into a cell (in a large array ie c1:z26) in sheet two , THEN the name that corresponds in that row(a1:a26) will be input into a certain cell in sheet one (aa1:zz52). The columns dont match up.. ARGH PLEASE HELP!!! Thanks, KAM |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com