Can Vlookup accomplish this?

[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?

 

[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