I have 2 spreadsheets. When I type in the vlook up formula and get to the
table array section I go over to the other spreadhseet and highlight the
range of cells (the table array) but its not picked up in the formula.

Any suggestions?

Thanks

Tariq...