How do I pull in a pay rate from another sheet when the identifier is on the sheet multiple times

Heather Mize

Trying to Index/Match - Help!

I need to pull the 'Total Base Pay - Amount' from another sheet into my current sheet by using employee ID as the match identifier, however there are 3 of the same employee ID on my current sheet.
I am guessing since there are 3 of the same employee id's on my first sheet, it's confusing things. Not sure what to do! Help?

This is the sheet I need to pull the rate from:

John_Foster

As long as you have the employee only once on the seconfd sheet you should not have an issue?

Have you looked at the VLOOKUP function?

=VLOOKUP([Emp ID]@row,XXX,NNN,false)

You would need to use a range from the second sheet in place of XXX and put the row number you wish to return in place of NNN.

John

Andrée Starå

How do I pull in a pay rate from another sheet when the identifier is on the sheet multiple times

Heather Mize

Jun 12, 2024

Trying to Index/Match - Help!

I need to pull the 'Total Base Pay - Amount' from another sheet into my current sheet by using employee ID as the match identifier, however there are 3 of the same employee ID on my current sheet.
I am guessing since there are 3 of the same employee id's on my first sheet, it's confusing things. Not sure what to do! Help?

https://us.v-cdn.net/6031209/uploads/OR250SW0QERO/main-sheet-png.png

This is the sheet I need to pull the rate from:

https://us.v-cdn.net/6031209/uploads/OAYVWVPIUIA9/indexmatch-png.png

---

View Post

Hi,

I hope you're well and safe!

Here's the structure for an INDEX/MATCH combination.

=INDEX({ColumnWithTheValueYouWantToShow}, MATCH(CellThatHaveTheValueToMatch@row,{ColumnWithTheValueToMatchAgainsTheCell}, 0)

INDEX Function | Smartsheet Learning Center

https://help.smartsheet.com/function/index

Returns an item from a collection based on provided row and column indexes

MATCH Function | Smartsheet Learning Center

https://help.smartsheet.com/function/match

Returns the relative position of a value in a range (lookup table). The first position is 1.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Heather Mize

I keep getting NO MATCH when I try both of those methods. Oy! Thanks for the responses!

Andrée Starå

Heather Mize

Jun 13, 2024

I keep getting NO MATCH when I try both of those methods. Oy! Thanks for the responses!

Happy to help!

Can you share some more screenshots where the formulas are shown? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!