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.