Take a look in the Excel help file for the VLOOKUP function. It contains
some good examples of what you want to achieve.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"carl" wrote in message
...
I have a table like so:

ColA ColB
ABC 2
EFG 1


Is there a formula that will look down ColA and if there is a match,
return
the value in ColB, but if there is not a match in ColA, return a blank.

Thank you in advance.

Carl