vlookup - can't pick up table array
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... |
vlookup - can't pick up table array
Highlight the table array then select InsertNameDefine then give the table
a name. In the vlookup formula type the name you have used to define the table. Ian "Tariq" wrote: 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... |
All times are GMT +1. The time now is 06:51 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com