CODEWITHSUNDEEP
excelvlookup
MunSka 2002
MunSka 2002

Reputation: 27

Excel Vlookup Column in another Sheet

So i have been playing with Excel for a while, and one thing led to another, i wanted to try this: How do i make the "Employee ID" cells in this Sheet here:

enter image description here

To refer to the "Employee ID" cells in this other Sheet?

enter image description here

Such that each employee in the first sheet have only their Employee ID rightfully and properly attached.

I have tried VLOOKUP but i keep getting N/A Errors despite my best efforts. Here is the Formula i tried in Excel:

enter image description here

The results returned was this:

enter image description here

Is there a solution to my predicament?

Upvotes: 0

Views: 1896

Answers (2)

Karl Emil Thulstrup
Karl Emil Thulstrup

Reputation: 67

You could also use XLookup, a relatively new formula. E.g., =XLOOKUP(A2;Sheet2!A:A;Sheet2!B:B)

Upvotes: 0

Solar Mike
Solar Mike

Reputation: 8415

You need index() with match() as vlookup cannot work to the left of its indexing column.

So try:

=index(Sheet2!A:A,match(B2,sheet2!B:B,0))

Typed without testing as you gave images not data.

Upvotes: 2

Related Questions