Thread: Index & Match
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phuser[_2_] phuser[_2_] is offline
external usenet poster
 
Posts: 14
Default 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 ))