Vlookup

[Nogger-01]

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.

 

[Gary''s Student]

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.