Hi,

Is there anyway you can get a vlook up to match two values to bring back a
number.

e.g.

A1 = Services numbers, 26 27
B1 = Depot Code
C1 = Registration Mumber

is there any way i can get the vlookup so that once i enter the service
number and the depot code then it brings back the correct registration
number. Need it as i have in some cases two of the same service numbers and
two diffrent regisrtation numbers

Thanks.

Use either AutoFilter or a helper column:

With AutoFilter you can set separate criteria on each column and pick the
correct result.

For the helper column in D1 enter:

=A1 & B1 and copy down. Then use this column for lookups.
--
Gary''s Student - gsnu200787


"Nogger-01" wrote:

Hi,

Is there anyway you can get a vlook up to match two values to bring back a
number.

e.g.

A1 = Services numbers, 26 27
B1 = Depot Code
C1 = Registration Mumber

is there any way i can get the vlookup so that once i enter the service
number and the depot code then it brings back the correct registration
number. Need it as i have in some cases two of the same service numbers and
two diffrent regisrtation numbers

Thanks.