| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup -Want to make table of array optional | Excel Discussion (Misc queries) | |||
| i want to do a vlookup but i want the table array to be changing | Excel Worksheet Functions | |||
| VLOOKUP - 3 Table Array | Excel Worksheet Functions | |||
| Table array in VLOOKUP (EXcel 2003) | Excel Worksheet Functions | |||
| How do i lengthen an existing VLOOKUP table array? | Excel Worksheet Functions | |||
Linear Mode
