vlookup produce N/A even the item look-up to does exist in table array

Hi guys.

I have plug in the vlookup on O10 to retrieve the code from table array Q11:R19.

Please Login or Register  to view this content.

It work just fine at first. However, it produce N/A in certain vlookup on certain items even that specific item does exist in the table array. I am tired trying to spot the mistake. For example in my workbook, when i change "Type" ( Interface!B11) to "Cleaner" , the vlookup in 010 is just fail. You may refer to my attachment for clear reference.

Can anyone point out the mistake to me?

Thanks in advance for helping.

hi again pyol17. your range should start from row 10:
=VLOOKUP(O10,Maintainance!$Q$10:$R$19,2,FALSE)
that is where the table starts & where "cleaner" is

=VLOOKUP(O10,Maintainance!$Q$10:$R$19,2,FALSE)