I am using the following formula:
=INDEX('120219'!$Z$13:$Z$112,MATCH($A2,'120219'!$B$13:$B$112,0))
However is the value in A2 does not exist in the B column of my table then it returns a random value and throws other values off as well. if there a work around?
=INDEX('120219'!$Z$13:$Z$112,MATCH($A2,'120219'!$B$13:$B$112,0))
However is the value in A2 does not exist in the B column of my table then it returns a random value and throws other values off as well. if there a work around?