CODEWITHSUNDEEP
excelexcel-formula
Morpheus
Morpheus

Reputation: 3

Excel Cross Reference Using LOOKUP

I have been given a task, in which I must go through a thousand entries on two excel sheets and copy over one value. They are not in the same order, so I have to manually search for each entry. I decided to try to make a function for this.

=LOOKUP(C113,'[RoleTree_2016-6-29]Sheet2'!E$2:E$2687,'[RoleTree_2016-6-29]Sheet2'!A$2:A$2687)

This function does not work properly, and I have no clue why. I am attempting to copy the A column variable where the E variable equals the target documents C variable. Can anyone help me?

Upvotes: 0

Views: 53

Answers (1)

tigeravatar
tigeravatar

Reputation: 26650

Try Index/Match instead:

=INDEX('[RoleTree_2016-6-29]Sheet2'!A$2:A$2687,Match(C113,'[RoleTree_2016-6-29]Sheet2'!E$2:E$2687,0))

Upvotes: 1

Related Questions