I am looking for a formula to lookup multiple values and return them in a single cell seperated by commas.
A sample of the data is as follows - there are 3 columns:
Code, Batch No, Location
If i entered the formula in a cell for code 1 and batch no 2 I would like it to return A1,A2. I have been using vlookup and if however it only returns the first value not multiple. Can anybody help me?