VLOOKUP in Excel

[funkylad20]

I have created as LOOKUP formula in a detailed excel spreadsheet.

The data where I am looking to 'lookup' from (the table_array) however is in column A and column N, rather than next to each other.

Is there a way of using two seperate columns without the need to copy and paste both sets of column data onto a seperate sheet/area on the worksheet?

[MarkRae]

Yep. Look up MATCH(), INDEX() and INDIRECT().