gregfthompson
asked on
Formula in excel to match corresponding values appears to work only for some cells
The attached file contains an INDEX formula in column E, that finds the inserts the name from column A, and where the number in Column B is the same as the number in Column F.
The problem is that this formula appears to not work in a lot of the rows starting at row E360.
Any help is solving this problem will be much appreciated.
Thanks,
Greg
Correspondence-problem-example.xlsx
The problem is that this formula appears to not work in a lot of the rows starting at row E360.
Any help is solving this problem will be much appreciated.
Thanks,
Greg
Correspondence-problem-example.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
The range in the formulae in Column E only extended to row 3252 when it needs to go to at least 6171.
I have attached an updated version with that fixed.
Alan.
Correspondence-problem-example---Ve.xlsx
The range in the formulae in Column E only extended to row 3252 when it needs to go to at least 6171.
I have attached an updated version with that fixed.
Alan.
Correspondence-problem-example---Ve.xlsx
LOL - Three answers in the space of a minute!
Just checked the range. It should be
=INDEX(A$1:B$6171,MATCH(F2 ,B$1:B$617 1,0),1)
=INDEX(A$1:B$6171,MATCH(F2
ASKER
Thanks.
I apologise for the dopey question.
I apologise for the dopey question.
Pleased to help
Open in new window