Conditional Lookup Function

  • Conditional Lookup Function 0

    1. simple formula (0) 0%
    2. Without VBA (0) 0%

    Dear Excel forum,


    Need help for following:-


    Data for once source
    Column A shipping container numbers (alpha & numerical)
    Column B the container size code
    Column C relevant date of arrival



    Data from another source
    Column D shipping container numbers (alpha & numerical)
    Column E the container size code
    Column F relevant date of shipment


    What I want is:
    If Column A containers match with Column B containers
    Then in Column G the containers that matched and Column H the container size code
    Column I the date of arrival
    Column J the date of shipment


    Vlookup seem to be an answer, but can’t get it to work.
    I am not good in VB, so may be formulas would be better
    Named range and IF & Match FORMULA may be?!!
    The list will be approximately 20,000 numbers long.


    Have attached the sample file.


    Kindly assist.


    Thanks & B.Rgds
    Krishnan

Participate now!

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