Posts by Sinnedy

    Re: VLookup multiple columns and return to a single cell seperated by commas


    Hi,


    I have been trying out your code for lookup all but i am unable to get the result i want.


    Assume that i have 3 columns A, B & C


    A B C
    AU -1 +1
    AU -2 +2
    AU -3 +5
    AU -4 +4
    ETC
    ETC



    I want to return all the positive values to a single cell with the values from column A infront separated by comma when the negative value in B matches with the positive value in C. eg. -1 & +1.


    "lookupall" would return AU1, AU2, AU4 all in a single cell.



    Please help and thanks in advance.