Posts by runwithit

    Please help correct or appropriately use the vlookup function.
    I have a list of values in columnA that may\maynot be available in columnB, if a value in columnA matches a value in columnB the status residing on columnC should be result of the function which I will associate in columnE toh the same values in columnA. (ColumnE or any other column can be used to house the results of the function)
    I am really sorry if this does not make sense. I have been trying so hard to figure this out, but I can not seem to get anywhere. Please look at the attached file to see if you can help me. I would really appreciate it any assistance with this. Thank you for your time.


    The current function I have is: E2=VLOOKUP(A2,B:B,C:C,FALSE).