Vlookup with multiple criteria is possible?

[julietterichelieu]

Hello!!!

I have a problem with excel and I will explain you with 2 pictures.

As you can see there is 2 slides "Inventaire" and "data" and i want to take the value from the sheet "data" and put it in the table in the sheet "inventaire"

So in the sheet "Inventaire" colum "L" (D) and "M" (E) i want all the data from the sheet "data" column "L" and "M" who have the same "Code valeur" and are "VMOB" (and not CPN, this is why i can't use VLOOKUP and filter only with the "code vaeur", I need 2 filter : "Code valeur" and "VMOB"....

As you can see in red, if i filter only with the "code valeur" there is 2 differents number associated with the same one in column "L" and "M". I would normally used VLOOKUP but this is not possible, or index but i don't know how to use it.

I hope this is clear...

Thanks in advance

 

[Fluff]

Duplicate to: Retrieve data from an Excel table into another table.

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.