Compiled Latest Revisions

[Mathew123]

As shown in below screen shot I have three revisions. Some sheets has all three revisions but has either one or two only. In the last column (TERMED AS FINAL in BELOW ) i need to show the latest revision.

SHEET	REV. 01	REV. 02	REV. 03	FINAL
P029-DDD-STR-0001	A	B
P029-DDD-STR-0002	A	B	C
P029-DDD-STR-0003	A
P029-DDD-STR-0004	1	B
P029-DDD-STR-0003	1		C

<tbody>
</tbody>

 

[JazzSP8]

Hi - Welcome to the Forum

So, it's just the last value in the row you want to return?

If so, try;

=LOOKUP(2,1/(NOT(ISBLANK(B2:D2))),B2:D2)

(Assuming you're starting on Row 2)

 

[Mathew123]

Hi - Welcome to the Forum

So, it's just the last value in the row you want to return?

If so, try;

=LOOKUP(2,1/(NOT(ISBLANK(B2:D2))),B2:D2)

(Assuming you're starting on Row 2)

Bravo Bro...it works ...thanks a lot...