Thread
:
lookup single value in a range and return specified value
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Teethless mama
external usenet poster
Posts: 3,718
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?
Reply With Quote
Teethless mama
View Public Profile
Find all posts by Teethless mama