| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup Help
Excel 2003 SP3
User formula is =VLOOKUP($A30,'ATS '!$A$2:$B$91,2). In sheet ATS she has data ending on row 74. She has allowed 91 rows to include new entries as needed in the future. However, the formula works intermittantly. For some entries she has to change the formula to $B$B80 (give or take a few rows). Is there a limit of blank rows that can be used in the lookup formula? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VLookup Help
Hi,
try this =VLOOKUP($A30,'ATS '!$A$2:$B$91,2,false) "Brenda from Michigan" wrote: Excel 2003 SP3 User formula is =VLOOKUP($A30,'ATS '!$A$2:$B$91,2). In sheet ATS she has data ending on row 74. She has allowed 91 rows to include new entries as needed in the future. However, the formula works intermittantly. For some entries she has to change the formula to $B$B80 (give or take a few rows). Is there a limit of blank rows that can be used in the lookup formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
