| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dynamic VLOOKUP function
I have a VLOOKUP function that looks something like this:
=VLOOKUP(A1,[Book3]Sheet1!$A$1:$C$3,3,FALSE) I want to be able to change the value of the workbook that's used for the lookup function. Let's say the workbook name is stored in B1. What do I need to do with the equation to get this to work? Thanks in advance, Barb Reinhardt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with VLookup function | Excel Worksheet Functions | |||
| Adding a Macro to a VLookup Function | Excel Discussion (Misc queries) | |||
| Vlookup w/Date Function | Excel Worksheet Functions | |||
| How can I see an example of the vlookup function in excel? | Excel Worksheet Functions | |||
| Regarding IF function or vLOOKUP function | Excel Worksheet Functions | |||
Threaded Mode
