C
Chris
I am getting a #Value result with the formulat
=index(Mej!$A$1:$B$123,match(B1,Mej!$B$1:$B$123,0),1The
problem is that it works for some cells, but as I drag it
down some cells end up with "#Value". I have no clue
what is causeing this. Any help would be appreciated.
SI also have tried using it such that in the match "B1"
is part of the "Mej!$B$1:$B$123" array with the same
results. any ideas.
=index(Mej!$A$1:$B$123,match(B1,Mej!$B$1:$B$123,0),1The
problem is that it works for some cells, but as I drag it
down some cells end up with "#Value". I have no clue
what is causeing this. Any help would be appreciated.
SI also have tried using it such that in the match "B1"
is part of the "Mej!$B$1:$B$123" array with the same
results. any ideas.