Help inserting into x and y table:

  • Hey guys do you think you could help me with this?


    [TABLE="class: cms_table"]

    [tr]


    [td][/td]


    [td]

    Packing Schedule: Part 1

    [/td]


    [td][/td]


    [td]

    x

    [/td]


    [td]

    y

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    SIZE

    [/td]


    [td]

    START TIME ON E-COAT

    [/td]


    [td]

    ARRIVAL TIME

    [/td]


    [td]

    DUMP STATION

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    LOG006

    [/td]


    [td]

    3:30 PM

    [/td]


    [td]

    7:30 PM

    [/td]


    [td]

    4

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    LOG007

    [/td]


    [td]

    3:30 PM

    [/td]


    [td]

    7:30 PM

    [/td]


    [td]

    1

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    LOG008

    [/td]


    [td]

    3:30 PM

    [/td]


    [td]

    7:30 PM

    [/td]


    [td]

    3

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    LOG011

    [/td]


    [td]

    3:30 PM

    [/td]


    [td]

    7:30 PM

    [/td]


    [td]

    5

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    LOG012

    [/td]


    [td]

    3:30 PM

    [/td]


    [td]

    8:30 PM

    [/td]


    [td]

    4

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    LOG022

    [/td]


    [td]

    3:30 PM

    [/td]


    [td]

    7:45 PM

    [/td]


    [td]

    5

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    LOG0111

    [/td]


    [td]

    3:30 PM

    [/td]


    [td]

    8:00 PM

    [/td]


    [td]

    6

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    Schedule: Part 2

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [td]

    DUMP STATION :

    [/td]


    [td]

    1

    [/td]


    [td]

    2

    [/td]


    [td]

    3

    [/td]


    [td]

    4

    [/td]


    [td]

    5

    [/td]


    [td]

    6

    [/td]


    [td][/td]


    [/tr]


    [tr]


    [td]

    TIME:

    [/td]


    [TD="align: right"]PM
    [/TD]

    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [TD="align: right"]PM
    [/TD]

    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [TD="align: right"]7:30 PM
    [/TD]

    [td][/td]


    [td][/td]


    [td][/td]


    [td]

    LOG006

    [/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [TD="align: right"]7:45 PM
    [/TD]

    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [TD="align: right"]8:00 PM
    [/TD]

    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [td][/td]


    [/tr]


    [tr]


    [td][/td]


    [TD="align: right"]What i want to do is have the size go into part 2 based on dump station indicated above and its time. I want for example LOG006 to go into the cell where the time is 730pm and dump station 4. You can see in part 1 it tells where it goes but i want a formula where it can automatically put the size into the correct column and row.


    Thank you!!!!!
    [/TD]

    [/tr]


    [/TABLE]

  • Re: Help inserting into x and y table:


    =IFERROR(VLOOKUP($B13&C$12,$J$3:$K$9,2,FALSE),"")


    problem solved.............................................................

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!