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


"Max" wrote:

Maybe you meant to do this:
=VLOOKUP(C11,Sheet2!$A$2:$B$410,2,0)

ie match C11 with Sheet2!A2:A410 &
return the corresponding value within Sheet2!B2:B410
in the formula cell

And if you need an error trap to return neat looking blanks: "" for any
unmatched cases instead of ugly #N/As, use this:
=IF(ISNA(MATCH(C11,Sheet2!$A$2:$A$410,0)),"",VLOOK UP(C11,Sheet2!$A$2:$B$410,2,0))

Adapt to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sarah" wrote:
Hi, I'm trying to get this formula to work, but it just keeps returning
"FALSE" into the cell. What am i doing wrong? Can anybody help me? Please???

I use excel 2003.

=IF(C11=Sheet2!A2:A410,(VLOOKUP(Sheet2!B2:B410,2,0 )))
--
Regards,
Sarah