VLOOKUP AND INDEX

[Paulo Delgado]

Hello Everyone!

Hope you are all well!

Can someone help me with the file attached and explain me why the function that i have made doesn't work properly??

Thanks in advace.
Paulo

 

[AliGW]

No idea what you are expecting it to do. Explain in WORDS, please.

 

[Paulo Delgado]

Hello!

Sorry, my mistake!

I would like to search numbers in those 4 different tables and when i select the 3 drop down menu with different options it should return a number that correspond in the tables.

I'm not sure if i was clear.

Thank you
Paulo

 

[Paulo Delgado]

The excel file, but now more intuitive.

thank you

 

[bosco_yip]

Change your formula :

From this >>

=INDEX((B4:D5,G4:I5,B9:D10,G9:I10),VLOOKUP(C12,N2:O3,2),VLOOKUP(D12,L7:M9,2),VLOOKUP(B12,L2:M5,2))

Into this >>

=INDEX((B4:D5,G4:I5,B9:D10,G9:I10),VLOOKUP(C12,N2:O3,2,0),VLOOKUP(D12,L7:M9,2,0),VLOOKUP(B12,L2:M5,2,0))

or,

=INDEX((B4:D5,G4:I5,B9:D10,G9:I10),MATCH(C12,N2:N3,0),MATCH(D12,L7:L9,0),MATCH(B12,L2:L5,0))

Regards

 

[Paulo Delgado]

Change your formula :

From this >>

=INDEX((B4:D5,G4:I5,B9:D10,G9:I10),VLOOKUP(C12,N2:O3,2),VLOOKUP(D12,L7:M9,2),VLOOKUP(B12,L2:M5,2))

Into this >>

=INDEX((B4:D5,G4:I5,B9:D10,G9:I10),VLOOKUP(C12,N2:O3,2,0),VLOOKUP(D12,L7:M9,2,0),VLOOKUP(B12,L2:M5,2,0))

or,

=INDEX((B4:D5,G4:I5,B9:D10,G9:I10),MATCH(C12,N2:N3,0),MATCH(D12,L7:L9,0),MATCH(B12,L2:L5,0))

Regards

Hello Bosco!

Perfect!

Now works correctly!

Thank you very much!

Best regards,