vlookup - can't pick up table array

T

Tariq

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...
 
I

Ian P

Highlight the table array then select Insert>Name>Define then give the table
a name. In the vlookup formula type the name you have used to define the
table.

Ian
 
Top