condition on two columns

[maroon1]

Hi everyody!

I need some advices about an operation I'm trying to do...
The file attachment exposes my gaol but I can explain it more precisely if necessary!

I have two questions:

1-Is it possible?? I think so but in fact I'm not sure...
2- Should I use 1 or 2 dictionaries?

Sorry for my English! And thank you very much for your answers!

[jindon]

For the data uploaded.

Please Login or Register  to view this content.

[maroon1]

It works perfectly!! Thank you very much!!
I have to adapt it with my real data base and for example the columns are not "joined"... I'm beginner and so if I can have some comments with the code it's really kind! For example what is "IIf"?
Then I think I could change it by myself... Thank you again!!

[jindon]

Please Login or Register  to view this content.

The last argument (bold part) for Index function should reference the column # for,
"I_PACAGE", "TYPE", "SURF_HA", 1,3,2 in your case.

That's all to adjust as long as the heading starts from A1 and no blank row(s)/Column(s) within data range.

[maroon1]

Ok thank you!!
And if I want to past the results in an other sheet? I tried that:

Please Login or Register  to view this content.

but it makes an index error...

[jindon]

Should be something like

Please Login or Register  to view this content.

Alter A1 to suite.

[maroon1]

That works!! Thank you very much for your help, you made me win a lot of time!!