Inserted Columns into VLOOKUP Tables
Instead of the original 3 that you had in your VLOOKUP formula, you
could have refered this directly to the columns of the original table,
i.e.:
VLOOKUP (A1, Sheet1!A:C, COLUMNS(Sheet1!A:C), false)
Then if two new columns are added to Sheet1 between columns A and C
the formula will automatically adjust.
Hope this helps.
Pete
On Apr 9, 1:44*pm, RJB wrote:
Thanks, my concern is where I DON'T know for certain changes have been
made over the life of the project. I guess I'm hoping someone posts
the "Don't you know about VLOOKUPAUDIT function" or something that
will help me trace through all the files and double-check data
integrity at this point.
You put too many people on a project, you're up all night cleaning
this stuff up. You don't put enough people on, you're up all night
doing the work.
I should have learned how to throw a football.
|