Simplify Lookup

[Thomas Kuriakose]

Respected Sirs,

Kindly let me know how we can simplify the below lookup formula -

=IF(AND(D$3=$A10,NOT(ISERROR(VLOOKUP(D$4&VLOOKUP($B10,PL,6,FALSE),TechKey,VLOOKUP($B10,PL,7,FALSE),FALSE)))),VLOOKUP(D$4&VLOOKUP($B10,PL,6,FALSE),TechKey,VLOOKUP($B10,PL,7,FALSE),FALSE),"")

Thank you very much,

with regards,
thomas

 

[Luke M]

Just to shorten it up a bit, can do this:

=IF(D$3<>$A10,"",IFERROR(VLOOKUP(D$4&VLOOKUP($B10,PL,6,0),TechKey,
VLOOKUP($B10,PL,7,0),0),""))

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for this solution.

I missed to attach the file in my post. Apologies for this error. There are 65,000 rows of data in sheet 3 and 2, I just clipped a sample.

Thank you very much once again.

Kindly find attached the file for your reference.

with regards,
thomas

 

[Luke M]

With example book, formula is very similar, just becomes:
=IF(C$1<>$A3,"",IFERROR(VLOOKUP(C$2&VLOOKUP($B3,PL,6,0),TechKey,
VLOOKUP($B3,PL,7,0),0),""))

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for the solution provided.

Much appreciated.

with regards,
thomas