Using multiple IF, AND & VLOOKUP but not more than 64 nests allowed.

[snehbiswas]

My requirements are:
1. Will select one drawing title from the list in cell E7.
2. When cell E7 is selected cell E9 must have the corresponding drawing number.
But the problem is that it accepts only 64 nests and I need atleast 250.

3. When the value in cell J9 changes to 1, 2 or 3, I want the date when it was done in the cells W14, X14 and Y14.

The actual file I am working on is attached.

Please help.

Thank you

 

[vletm]

snehbiswas
2. If You write to cell E9 eg =INDEX(S14:S110,MATCH(E7,T14:T110,0))
then You'll get that the corresponding drawing number from S-column.
3. Where are Your named the date?

 

[snehbiswas]

snehbiswas
2. If You write to cell E9 eg =INDEX(S14:S110,MATCH(E7,T14:T110,0))
then You'll get that the corresponding drawing number from S-column.
3. Where are Your named the date?

Thank you very much "VELTM" for you prompt reply and resolving one of my problems.

The other thing I want, if possible, is when the value in J9 is "1" I want the current date when it was changed from "0" to "1" in the cell W14, when the value in J9 is "2" I want the date when it was changed from "1" to "2" in the cell X14, when the value in J9 is "3" I want the date when it was changed from "2" to "3" in the cell Y14.

Thank you so much again.

 

[vletm]

snehbiswas
Selection with cell E7 gives cells J5 and E7 value.
If You change from 0 to 1, from 1 to 2 or from 2 to 3
then current date should record to active drawing title row.

 

[snehbiswas]

Thank you for your reply. Actually what I want is this:
1. Suppose I created a file on 04.09.22. That date will be written in cell D9 permanently. Initial file so cell J9 =0.
2. Suppose I made some changes and then mark as Revision-1 in cell J9 =1 on 12.09.22. I want this date 12.09.22 to come automatically in cell X14.
Thank you again.

 

[vletm]

snehbiswas
Isn't my sample work so?
... if You'll mark 1 to cell J9 next Monday ... there should come that day
... and so on.

 

[snehbiswas]

snehbiswas
Isn't my sample work so?
... if You'll mark 1 to cell J9 next Monday ... there should come that day
... and so on.

Sir, Thank you but I am sorry that I didn't see any changes.

Thanks

 

[vletm]

snehbiswas
Your above file is different than my #4 reply's file
and it won't work as I've written ... or You've written.
Did You test my previous file at all?
Do You have macros enabled?

 

[snehbiswas]

snehbiswas
Your above file is different than my #4 reply's file
and it won't work as I've written ... or You've written.
Did You test my previous file at all?
Do You have macros enabled?

OK Sir. Got it. Macros were disabled.
Thank you very much.