Share via

Excel, how to set A1=B1, A2=C1 in excel?

Anonymous
2017-10-11T04:51:02+00:00

I am making a table for name list with date and schedule.

In the same sheet, the first table is for attendance 

A1 to L1 is No. of Lesson

A2 to L2 is date 

L1 L2 L3 L4 L5 L6 L7 L8 L9 L10 L11 L12
21-Aug 23-Aug 28-Aug 30-Aug 04-Sep 06-Sep 11-Sep 13-Sep 18-Sep 20-Sep 25-Sep 27-Sep

 The second table is for teacher remark what they teach in the lesson. A4 to A11 is No. of Lesson 

 B4 to B11 is the date 

 C4 to C11 is teacher's remark

L1
L2
L3
L4
L9
L10
L11
L12

How to make automatically B4 to B11 same as A2 to L2 ?

Thank you!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-10-11T05:04:17+00:00

    Enter below formula in cell B4 & copy down:

    =HLOOKUP(A4,$A$1:$L$2,2,FALSE)

    Regards,

    Amit Tandon

    www.globaliconnect.com

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2017-10-11T05:59:14+00:00

    Thank you Amit

    0 comments
  3. Anonymous
    2017-10-11T06:13:41+00:00

    You are welcome.

    If the said response (not this one but above) answers your question then please mark as Answer.

    Regards

    0 comments