LookUp Type Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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$200),"")

where D2 houses a lookup value of interest.
 
Back
Top