![]() |
#13
|
||||
|
||||
![]()
I'm working my way through that (rather long) article now. I can already see one improvement in future lookups. One problem with VLOOKUP is that the target column must be to the right of the index column; wherever that's not the case, I used to use MATCH with INDIRECT to construct a pointer to the desired value. I recently realized that OFFSET is better than INDIRECT. But INDEX: is better yet. I'll keep reading.
Oh, and by the way, I never knew about the IFERROR function. That's marvelous! |
Tags |
if/and, vlookup |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
VLookup formula Problem (salary plus (commission x sales)) | topgear2015 | Excel | 11 | 06-05-2013 09:02 PM |
![]() |
ladygogo78 | Excel | 3 | 10-22-2012 12:28 AM |
IF + VLOOKUP formula help | skyline255 | Excel | 0 | 09-19-2012 05:05 PM |
Help with VLOOKUP formula | pattyr | Excel | 6 | 08-20-2012 02:20 AM |
Using IF & VLOOKUP together | junction | Excel | 7 | 11-18-2010 05:15 AM |