Double if conditions to match then add to an existing dictionary

Hello there,

i'm trying to create a code that will allow me to check if i match on the column A and C both condition "Car" and "Red"
if yes i want to fill my existing DicoRedCar with the Brand of the Car as item and Price as Key
here is my code :

Please Login or Register  to view this content.

column 1 vehicule type
column 2 brand of the car
column 3 Color of the car
Column 6 Price of the car

but it does not feed the Dico i know that on range A24 i have a red car appearing
but nothing happens i tried to check with a MsgBox for the Then Statement but it gave me nothing
i tried this but nothing happened

Please Login or Register  to view this content.

so i think that the blocking point came first from my " if then " statements

thanks you for your help

Welcome to the Forum.
In future please view the forum rules before posting. Your post does not comply with rule #3.
3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.

So do the following:
Go to original post, Highlight your code and click the [#] button at the top of the post window.

Your tests are case-sensitive which could explain the problem (we can't see the data so it is hard to say!).

Please Login or Register  to view this content.

There you are- the cells contain "red" and not "Red" as in the code. Use

Please Login or Register  to view this content.

to make everything the same case.

Well deduced @xlnitwit

@KAYABRFR
- VBA and Excel are not always consistent - it can be confusing

Type this formula in a cell in Excel - formula returns TRUE

Formula:

Please Login or Register  to view this content.

Run this VBA code - message box returns FALSE

Please Login or Register  to view this content.

Also quite rude to cross-post without links, especially when people are answering you!