if(match question

[eprice]

Hello,

I am trying to automate some financial monthly reports and I am trying to figure out the best way to complete this formula or suggest a new formula if you do not think the formula is sound. I am using the Match function to find the row the value is located in this case the account number. I then want to have data that follows that row designated and report the data from a certain cell in that row.

=if(MATCH("101100",'Data Sheet'!$B$2:$B$997,0),the match result + 2 cells over in the same row found. )

[JBeaucaire]

INDEX the column you want the value from first, then use the match to choose the row from that index:

=INDEX('Data Sheet'!$D$2:$D$997,MATCH("101100",'Data Sheet'!$B$2:$B$997,0),1)