Thread
:
Index & Match
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
phuser[_2_]
external usenet poster
Posts: 14
Index & Match
Im having a brain fart here, and cant see the error
the formula is in C4, A Column contains the match as well as BE, the number
in BF is currency
=(INDEX($BE$3:$CS$300,MATCH(+A4,$BE$3:$BE$300,0),2 ))
Reply With Quote
phuser[_2_]
View Public Profile
Find all posts by phuser[_2_]