Try this:

=VLOOKUP(A4,Sheet2!B$2:C$10,2,0)

--
Biff
Microsoft Excel MVP


"KenCanuck" wrote in message
...
I have 2 worksheets. I need to have a formula that reads cell (Ex.) A4 in
Sheet 1 then references Sheet 2 to match that text out of a list (B2-B10)
and
supply the corresponding value in (C2-C10). This result (the formula)
will
be in cell B4 on sheet 1. I thought it was a MATCH function but I can't
get
it to work.

Thanks! - Ken