How to Automatically Fill in a Field in One Spreadsheet Based Another?

[webdivx]

I have the attached workbook (spreadsheet.xlsx) with 2 spreadsheets

The first sheet (called "Sheet1") has a column for ID, last name, first name, etc. The ID is blank and I want to populate them based on the last name and first name fields in column B and C.

pic-1.png

The second sheet (Called "Sheet2") has the IDs for each person. What formula will allow me to pull the IDs from "Sheet2" and populate it in the corresponding ID field in Sheet1?

For example, I want all instances of Brock, Eddie in "Sheet1" to have the "ID" 2 since that is the corresponding ID in "Sheet2".

pic-2.png

[FlameRetired]

The file you have uploaded has a format newer than the Excel 2003 your profile indicates. Please update your profile so we can know which of the newer functions/features you actually have available.

[webdivx]

The file you have uploaded has a format newer than the Excel 2003 your profile indicates. Please update your profile so we can know which of the newer functions/features you actually have available.

Thank you for bringing this to my attention. I am using Excel 2013 and have updated my profile to reflect that.

[FlameRetired]

Array enter this formula in A2 and fill down.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Please Login or Register  to view this content.

[FlameRetired]

Two alternatives to my formula in post #4 above that do not have to be array entered.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[webdivx]

Two alternatives to my formula in post #4 above that do not have to be array entered.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you so much, the first formula in this post was exactly what I needed!

[FlameRetired]

You are welcome. Thank you for the feedback and added rep.

One last thing ... If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.