Lookup required

[Drewmyster]

I doubt this can be done, but I want to look up numerical data from a column and return a text string.

If A1 = “Test” and if B1 = “Test”

Column B contains cells with the numbers 1, 2, 3, 4 and 5

Then look up (from bottom to top) and return all the data in column B as a text string (e.g. 1-2-3-4-5).

Any way to make this work?

Thank you.

 

[maabadi]

You can help from ISTEXT or ISNumber Formula. Please upload your Example file With XL2BB ADDIN (Preferable) or free hosting site e.g. www.dropbox.com , GoogleDrive or OneDrive & insert Link here