Hello

I would like to add a column to a spreadsheet that pulls data from another sheet, where the target cells have both text and numbers. I would like the VLOOKUP to scan 6 columns in another spreadsheet, Ignore the text so that it can find the highest number out of those 6 columns and show me in one cell on my main spreadsheet the highest number along with the text that would come before it.

If anyone can help with this it would be much appreciated

Oscar