Enter data based on 2 different cells, 2 columns, different sheets

**mollybop** · 11-28-2018, 11:15 PM

Hello
I have a grading Master book, specifically the sheet "Indiv Grading Form" I want to be select a students name in B2 and then have the information filled into the cells (C4:j4, c7:j:7...)based on the first name and the discipline (pulling the grades from sheet Master Grades).

I think that I'm close to figuring it out but there's obviously a small issue because it's the same number and it doesn't seem to be the correct number.

Ive attached the file, any assistance would be greatly appreciated.

Thank you

**benishiryo** · 11-28-2018, 11:47 PM

hey there. change cell C2 to "Term 1" to standardize between both worksheets. then:

Formula:

Please Login or Register  to view this content.

you didn't mention what are the answers supposed to be though. so that's just a guess.

non-related: is your date format at the bottom of your windows showing YMD? if so, could you type 9feb2014 and see if it aligns to the right? i used to be able to do that in YMD settings, but strangely can't do it now.

**Bo_Ry** · 11-28-2018, 11:51 PM

Please try at Indiv Grading Form C4:J4 and copy to row 7, 10, 13

=IF(C3="","",INDEX('Master Grades'!$D$3:$AG$26,MATCH($B$2,'Master Grades'!$A$3:$A$26,),COLUMNS($C4:C4)+MATCH($J3,'Master Grades'!$K$1:$AG$1,)-1))

**mollybop** · 11-29-2018, 05:05 AM

This worked! Thanks so much!

Enter data based on 2 different cells, 2 columns, different sheets

LinkBack

Thread Tools

Rate This Thread

Display

Enter data based on 2 different cells, 2 columns, different sheets

Re: Enter data based on 2 different cells, 2 columns, different sheets

Re: Enter data based on 2 different cells, 2 columns, different sheets

Re: Enter data based on 2 different cells, 2 columns, different sheets

Thread Information

Users Browsing this Thread

Similar Threads

VBA To enter certain data the concatenate cells in columns

[SOLVED] Formula to pop data from mult cells from one WS to another based on data enter in a cell

Enter data into cells based on single cell data

[SOLVED] Enter text in column a based on data in several other columns for groups of rows

Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

Compare 2 columns in 2 sheets then enter data from a 3rd cell? Help!

Enter and highlight data in columns based on other columns

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions