lookup single value in a range and return specified value
 

I have a value in A9 that i want to look up in range B2:B6 and return an X if
it is there and blank if it is not. How?

lookup single value in a range and return specified value
 

One way:

=IF(COUNTIF(B:B,A9)0,"X","")

HTH,
Paul

"bjw" wrote in message
...
I have a value in A9 that i want to look up in range B2:B6 and return an X
if
it is there and blank if it is not. How?

lookup single value in a range and return specified value
 

hmm...thought i tried that already but i must have missed something...
Thanks, it worked!

"PCLIVE" wrote:

One way:

=IF(COUNTIF(B:B,A9)0,"X","")

HTH,
Paul

"bjw" wrote in message
...
I have a value in A9 that i want to look up in range B2:B6 and return an X
if
it is there and blank if it is not. How?

lookup single value in a range and return specified value
 

=IF(ISNUMBER(MATCH(A9,B2:B6,0)),"X","")


"bjw" wrote:

I have a value in A9 that i want to look up in range B2:B6 and return an X if
it is there and blank if it is not. How?