|
|
#2
03-06-2017, 08:26 PM
|
|||
|
|||
Well let's say your Vlookup is =VLOOKUP(A1,$D$1:$E$8,2,0)
If you add a record to row 9, the VLOOKUP would fail because it is not a dynamic range. So instead, reference the entire column =VLOOKUP(A1,$D:$E,2,0) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Help using If and Vlookup
|
heastlund | Excel | 3 | 08-04-2014 01:34 PM |
|
IF and VLOOKUP
|
SBMC | Excel | 1 | 11-07-2012 10:24 AM |
|
Using IF and VLOOKUP together
|
Becki | Excel | 2 | 04-06-2012 05:32 PM |
| Vlookup | ibrahimaa | Excel | 8 | 01-03-2012 09:32 PM |
| Vlookup | Karen615 | Excel | 4 | 09-12-2011 02:30 PM |
Windows Vista 
Office 2007
Threaded Mode