• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

snehbiswas

New Member
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
 

Attachments

  • 1200CCRDB.xlsx
    36.7 KB · Views: 4
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
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.
 
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.
 

Attachments

  • 1200CCRDB.xlsb
    32.4 KB · Views: 5
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.
 
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?
 
Back
Top