Welcome, glad it helped.

.. I have information in cell C2:C410 and D2:D410 of Sheet2!,
which also is dependant on what i enter into C11 of Sheet1!.

If you meant to extract info from col C and D in Sheet2
you could use these:
In say, E11: =VLOOKUP(C11,Sheet2!$A$2:$D$410,3,0)
In say, F11: =VLOOKUP(C11,Sheet2!$A$2:$D$410,4,0)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote in message
...
Hi Max,

Thank you!!! That is exactly what I wanted to do Max. However....I have
information in cell C2:C410 and D2:D410 of Sheet2!, which also is
dependant
on what i enter into C11 of Sheet1!. How do I overcome this Max?
--
Regards,
Sarah