|
|
#5
03-07-2017, 05:33 AM
|
|||
|
|||
You're very welcome.
I agree, the entire column reference might be overkill, so instead of $D:$E you could extend to a reasonable length which would catch the new adds. Maybe $D$1:$E$200 would suffice 
|
|
|
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