Drawing revision control

[thisara]

hi all,

I am trying to build a drawing revision control. Here with i attached what i created.
basically what i need is to find the latest drawing Revision and created date of that drawing.
The problem with my excel sheet is only work with numbers (revision cells=F9,G9,H9,...). If i enter text for version it does not work.

Regards,

[:) Sixthsense :)]

May be this...

In D9 Cell

=INDEX($F$8:$CG$8,MATCH(C9,$F$9:$FI$9,0))

[thisara]

thank you,

I need Formula for C9 Cell.

Regards

[:) Sixthsense :)]

In C9 Cell

=IFERROR(LOOKUP(2,1/($F9:$BL9<>""),$F9:$BL9),"")

Drag it down...

[:) Sixthsense :)]

Thanks for the rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.