List lookup 2

[Blazerdog]

I have a list of lets say

a
b
d
j
k
e

I want a function to look on that list and return a positive if the letter I indicate is on the list. An if function would be =if(??="j","x"," ") with ?? being the cell that I put the lookup value in.

I have a list an I want to see an X in a column if there is a a certain value in that column.

I hope this makes sense.

 

[IDS]

If your lookup value is in cell A1, and your list is in the range "list", then:
=MATCH(A1,list,0)
will return a row number if A1 is in the list, or #NA# if not.

Wrap that in IFERROR():
=IFERROR(MATCH(A1,list,0),0)
and it will return 0 rather than #NA# if A1 is not in list.

Finally, wrap that in an IF() function:
=IF(IFERROR(MATCH(A1,list,0),0)>0,"X","")
and it will return X if A1 is in list, or a blank if not.




Doug Jenkins
Interactive Design Services

http://newtonexcelbach.wordpress.com/

 

[dik]

Thanks, Doug

Don't have a use for it yet, but, pretty sure I'll find something.

Dik

 

[Blazerdog]

Doug,

That is what I needed. Thanks a bunch.