@wskip49

Just for thought...

If the data is from multiple columns in a lookup value, Index/Match is more efficient from what i know.
VLOOKUP and MATCH invokes the same routines so really no significant difference.(plain vlookup function)

try to experiment on using vlookup and index/match in a sample of your file, if who performs faster in your data then you use that.

@ martin, sir can you give us some more points with this regards using your formula, for the sake of learning....