Can Vlookup accomplish this?

O

osp

Hey Biff I tried that formula and it works. Then I tried applying that
to this spreadsheet at work and it works for the first cell but when I
copy and paste it down the rest are incorrect. Any advice on what to do
from here?
 
B

Biff

Hi!

It should work when you drag copy it down. Did you change
the range in the MATCH function lookup_array to suit your
actual setup? That's the only reason that I can think of
that might be causing you a problem.

Biff
 
Top