Mike,

Try something like

=VLOOKUP(A1, B1:C500, 2, FALSE)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Mike" wrote in message
...
I can't get my head around the syntax of a formula for lookup.

Formula is in D1
1 have a number in cell A1
I want to find a match for the number in column B
and then return the value in column C in the same row as the match was
found.

Help much appreciated.

mh