VLOOKUP - Find more data by extending row and column

[hassanyf]

G'day

I am trying to use this VLOOKUP formula from here. But no matter how much I change the formula, it breaks/doesn't work.

The current formula extends till 8 row and 8 column. How do I extend the formula to 12000 row and 5 column?

I would really appreciate anyone solves the formula.

Thanks

 

[AhoyNC]

Are you trying to change the INDEX/MATCH formula in the link? The formula in the link is for 8 rows & 2 columns (not sure where you get 8 columns).
We need more info. based on your worksheet.
1-What column has the data you want to return (it was A in the link)
2-What cell has the criteria you are looking up (it was E1 in the link)
3-What column has the data for the criteria (it was B in the link)