| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Copy VLOOKUP Formula
The formula in B1 would be VLOOKUP(A1, etc). Since you're going to
copy this down a column, here's a tip: when you define the look-up range in the VLOOKUP use reference anchors (for instance, $D$1:$E$10) to lock the range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a formula with relative ref. keeping the same ref.? | Excel Discussion (Misc queries) | |||
| Vlookup formula Excel version 2002 | Excel Discussion (Misc queries) | |||
| IF / VLOOKUP formula won't work until saved | Excel Worksheet Functions | |||
| Display the max, then the next down, then the next down, etc. | Excel Discussion (Misc queries) | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Threaded Mode
