Is it possible to look up more that one column at a time?

For example: My spreadsheet has up to 12 twelve columns with batch numbers in them, but I need to search all columns at once. It is worth noting that I have sorted all columns by Autofilter.

Thanks

Dave