Thread
:
Lookup value in range, then if that value is something do a calculation.
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Richhall
external usenet poster
Posts: 19
Lookup value in range, then if that value is something do a calcul
Thanks, what does the -- do? WHy doesn't =IF(Sheet1!A$2:A$100=A2,1,0)
bring back 1 or 0 for me?
Reply With Quote
Richhall
View Public Profile
Find all posts by Richhall