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

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

If you'd want to sort A:B on A in ascending order and to maintain the
A:B in ascending order:

=IF(LOOKUP(D2,$A$2:$A$200)=D2,LOOKUP(D2,$A$2:$B$20 0),"")

where D2 houses a lookup value of interest.

carl wrote:
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