Match cells from one sheet to another, and return specific data

**Losguapos1** · 01-13-2019, 05:12 PM

Good Afternoon,

I need some help getting my spreadsheet to do what i want it to do. What i looking for is on the sheet labeled Demographic Info, i need it to reach Student Data and match the student names on each sheet and fill in the columns (*** Ethnicity Lunch SPED ELL).

I have attached a sample and the first few line have been completed.

Any help would be greatly appreciated

Los

**TMS** · 01-13-2019, 05:20 PM

Cell D2:

Formula:

Please Login or Register  to view this content.

Copy across and down

**Losguapos1** · 01-13-2019, 08:08 PM

When i try that I get #N/A in all of the cells.... Not sure why that is happening....

NVM..... figured it out, my original data had a leading space when i downloaded it.....

thank for the solution!!!

**TMS** · 01-14-2019, 02:42 AM

You're welcome. Thanks for the rep.

Match cells from one sheet to another, and return specific data

LinkBack

Thread Tools

Rate This Thread

Display

Match cells from one sheet to another, and return specific data

Re: Match cells from one sheet to another, and return specific data

Re: Match cells from one sheet to another, and return specific data

Re: Match cells from one sheet to another, and return specific data

Thread Information

Users Browsing this Thread

Similar Threads

2010 - Need to match data and return specific cell value - SUMIF? MATCH? INDEX? HELP!

[SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value

Excel: match two cells in one sheet to two cells in another and return a third cells value

Excel: match two cells in one sheet to two cells in another and return a third cells value

Excel: match two cells in one sheet to two cells in another and return a third cells value

[SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value

[SOLVED] Excel: match two cells in one sheet to two cells in another and return a third cells value

[SOLVED] How can I lookup cells that match a specific value and return all.

Bookmarks

Bookmarks

Posting Permissions