Posts by Sinnedy

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


    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

    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.