Sort not working correctly when using Index Match Formula

[luc_09]

Hi,

I am using an index/match formula to return ids from another sheet
However, when I sort the ids doesnt sort correctly and ends up messing up the index/match formula. It seems to sort the persons name bt the formula then changes where it is looking up a different cell.

Is there something to be aware of when using Sort and index/match?

EID

 

[RoryA]

Welcome to the forum!

Can you clarify what exactly you mean? What are you sorting and what happens?

 

[luc_09]

Welcome to the forum!

Can you clarify what exactly you mean? What are you sorting and what happens?

hey,
sorting by color when I do that the Employee ID gets mixed up

 

[RoryA]

Can you give a specific example? There is nothing in that formula that should be able to get mixed up as it uses the name on the current row. Unless perhaps you have calculation set to manual?