EXCEL Lookup formula

  • hi guys... please help me with these problem.. i have no excel-vba programming background so please bear with me...
    -here's the problem


    i have a column(E) "Order Placed" and column(F) "order Received"
    if i typed in a value in Col(E) example : E(13) = 5000
    the same value should appear in col(F 25), this means that the same value should appear after 12 cells in Column F


    ---------
    another example... if col(E 20) = 2500 col(f 32) = 2500 also..


    how do i do this... please help.. kinda urgent :yikes:

  • Thank You So Much!!!


    thanks jindon... i didn't know it can be done by a formula... seems like my teacher's kinda well...dumb ( i dont know how to put it sensitively).. hehehehe... he says it can only be done in vba... thanks so much.. thanks to ROYUK also

  • Quote from killerkamatis

    seems like my teacher's kinda well...dumb ( i dont know how to put it sensitively).. hehehehe...


    Well you know the old saying...


    Quote

    "Those that CAN, DO
    Those that CAN'T, TEACH!"


    That's why forums are great learning resources, as you are tapping the knowledge of the DOERS as opposed to PAYING the TEACHERS


    :guitar: :guitar: :tongue:

  • Hi,


    OK. what you got is exactly the same result as


    in cell F23
    =if(E12="","",E12)
    simple as above!


    =INDIRECT("E"&ROW()-12)
    also returns the same value


    Check excel help carefully and it is easy to understand.


    Good Luck!
    jindon


    By the way, here's VBA code
    Paste code in sheet module


    Private Sub Worksheet_Change(ByVal Target As Range)
    with target
    if (.column<>5)+(.count<>1) then exit sub
    .offset(12,1).value=.value
    end with
    end sub

Participate now!

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