Re: Tough Excel Question
[ QUOTE ]
And you have to sort the data by that column, I believe.
[/ QUOTE ]
For a real vlookup, this is true. Which is why it is often preferable to use Index(DataColumn, Match(LookupValue, KeyColumn,0),false) instead of a true vlookup. The Index and Match functions are also more flexible than vlookups.
[/ QUOTE ]
I'm so glad I came into this thread. I've learnt something that will be very useful.
|