Excel xlookup without knowing lookup columns

[Pswov]

I currently am working with data that is not very consistent in formatting. There are a lot of small exceptions that I work with in my data that make columns and rows not consistent in formatting (ex: column G in one spreadsheet could line up with column K in another). I was wondering if there is an actual way to do a lookup on an entire range instead of just a row and columns with lookup or without something like a VBA range.find. Is there any way to do this type of lookup?

 

[Jeffrey Mahoney]

You can. Inside your vlookup for the column, you can use MATCH. Match to the column header name.

 

[Automatrix]

If you format your data in the spreadsheets as named tables, you can reference the column names regardless of their positions.