Link to home
Start Free TrialLog in
Avatar of gregfthompson
gregfthompsonFlag for Australia

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
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Try this...

=INDEX(A:A,MATCH(F2,B:B,0))

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Roy Cox
Roy Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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$6171,0),1)
Avatar of gregfthompson

ASKER

Thanks.

I apologise for the dopey question.
Pleased to help