3 ms·vlookup is usually not the right tool for the job (index + match better)by mhh__ 3y agovlookup is usually not the right tool for the job (index + match better)cm2187 3y agoOr xlookup if you are younger.