| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP HELP!!
I have multiple Vlookup that are run by a MACRO. I Inserted lines on the
sheet below where the Vlookups are supposed to run. Now my Vlookups dont work, when I run the macro it brings up a dialog box looking for the file containing the lookup values. When I update the link from the edit menu it still does that same thing. It is pulling the values off a network. I am very confused and frustrated. Any suggestions welcome. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP HELP!!
Where does the error occur? You know macros do not adjust to changes. It's
probably referencing to an invalid cell or worksheet. Copy and paste where you got the error and we'll take a look at it. "DP7" wrote: I have multiple Vlookup that are run by a MACRO. I Inserted lines on the sheet below where the Vlookups are supposed to run. Now my Vlookups dont work, when I run the macro it brings up a dialog box looking for the file containing the lookup values. When I update the link from the edit menu it still does that same thing. It is pulling the values off a network. I am very confused and frustrated. Any suggestions welcome. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | |||
| IF(a1="x",(vlookup 18K rows,2,false),(vlookup 18K,3,false)) RAM? | Excel Worksheet Functions | |||
| IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Hybrid Mode
