Thread: lookup and if?
View Single Post
  #1   Report Post  
Kerry
 
Posts: n/a
Default 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