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
|