| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problem with Vlookup array selection
Anne Troy wrote: That's why I always use named ranges for my vlookups (whenever reasonable to do so), as described he http://www.officearticles.com/excel/...soft_excel.htm But you need to reference absolutely your table: =VLOOKUP(A2,'sheet2'!$A$1:$A$510,1,FALSE) :) Ahh, the dollar signs for absolute, that's what I needed. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Problem | Excel Worksheet Functions | |||
| Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
| How to use a cell value as Table Array in VLOOKUP worksheet function | Excel Discussion (Misc queries) | |||
| Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
Threaded Mode
