Combine two Vlookups

Hi,

Is possible to combine two Vlookups ?


Basically, I have two VLOOKUPS i.e.

Please Login or Register  to view this content.

=VLOOKUP(A2,'Data'!B:L,11,0)

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

=VLOOKUP(B2,'Data'!A:L,12,0)

Please Login or Register  to view this content.

which are using the fields ‘Ref’ and ‘Project Number’ which looks up the value ‘Project Type’ from the ‘Data’ tab in column ‘L’.

I need to combine these two Vlookups as not every record has a ‘Ref’ and ‘Project Number’ in order to ensure I capture the ‘Project’ Type’.

Currently I have two lookup columns i.e. ‘C’ and ‘D’ on the ‘Master’ tab and the in column ‘E’ use a MAX formulae to populate the ‘Project Type’. My problem here is the ‘Project Type’ can be either 0, 1, 2, 3 or 4 and this formula pulls through any null values as 0 and also display #N/A. Please see attached file ‘VLOOKUP DATA.xlsx’

Any assistance would be great appreciated

Many thanks in advance

Regards

Rob

Does this work?

=IFERROR(VLOOKUP(A2,'Data'!B:L,11,0),IFERROR(VLOOKUP(B2,'Data'!A:L,12,0),"ID & Project Number not on file")

Some of your Project Numbers are duplicated in the Master file but have different IDs.

Sprecial-K

EXCELLENT !!

Many thanks

Regards

Rob