View Single Post
  #1   Report Post  
Skye1973 Skye1973 is offline
Junior Member
 
Posts: 3
Default Index Match function for lookup HELP

I have two worksheets where I am wanting to match data on tab 1 to data on tab two and return the intersecting value. I am using the formula below and keep returning the value of 0?

=IF(ISERROR(INDEX(Citrus!$A$1:$I$539,MATCH(A5,Citr us!$A$1:$H$296,0),MATCH($D$1,Citrus!$A$1:$Z$1,0))) ,0,INDEX(Citrus!$A$1:$I$539,MATCH(A5,Citrus!$A$1:$ A$296,0),MATCH($D$1,Citrus!$A$1:$Z$1,0)))

What am I doing wrong?
Attached Files
File Type: zip example.zip (52.7 KB, 67 views)