Searching and returning information ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Okay, this is what I am TRYING to make happen with my spreadsheets . .

I have two separate sheets "INSTRUMENTS" and "GRADES".

On the "GRADES" sheet, I have listed each student's name in column A. Columns B thru F have been left empty.

On the "INSTRUMENTS" sheet, there are 5 columns. Column A is labeled Monday, Column C is labeled Tuesday, Column E is labeled Wendesday, etc. Beginning with cell A4, I would like to be able to type in the student's name ONLY if their instruments were left at school overnight. These names will be in random order and there may be as many as 20 names per column on this sheet

Ideally what I would like to have happen is . . . on the "GRADES" sheet, cell B4 will search the range A4;A24 on the "INSTRUMENTS" sheet for the student's name and if found would place an "X" or some other "mark" in B4. If the name is not found B4 will be left empty. Cell C4 will search the range C4;C24 on the "INSTRUMENTS" sheet for the student's name and if found would place an "X" or some other "mark" in C4. If the name is not found C4 will be left empty and so on . . .

Any help you can give would be greatly appreciated
Thanks!
 
Ebony,

In cell B4 on GRADES, use the formula

=IF(ISERROR(MATCH($A4,Instruments!A$4:A$24,FALSE)),"","X")

and copy to cells B4:F24.

HTH,
Bernie
MS Excel MVP

EbonyMonarch said:
Okay, this is what I am TRYING to make happen with my spreadsheets . . .

I have two separate sheets "INSTRUMENTS" and "GRADES".

On the "GRADES" sheet, I have listed each student's name in column A.
Click to expand...
Columns B thru F have been left empty.
On the "INSTRUMENTS" sheet, there are 5 columns. Column A is labeled
Click to expand...
Monday, Column C is labeled Tuesday, Column E is labeled Wendesday, etc.
Beginning with cell A4, I would like to be able to type in the student's
name ONLY if their instruments were left at school overnight. These names
will be in random order and there may be as many as 20 names per column on
this sheet.
Ideally what I would like to have happen is . . . on the "GRADES" sheet,
Click to expand...
cell B4 will search the range A4;A24 on the "INSTRUMENTS" sheet for the
student's name and if found would place an "X" or some other "mark" in B4.
If the name is not found B4 will be left empty. Cell C4 will search the
range C4;C24 on the "INSTRUMENTS" sheet for the student's name and if found
would place an "X" or some other "mark" in C4. If the name is not found C4
will be left empty and so on . . .
 
Back
Top