Display last status information

[js]

Dear all,
I'd like to display last status of my projects in sheet2 based on data on
sheet1 as follows:

SHEET1:
Project Day1 Day2 Day3 Day4 Day5 Day6 Day7
X Status1 Status2 Status3
Y Status1 Status2 Status3 Status4 Status5

SHEET2:
Last Status Information:
X Status3
Y Status5

Can someone help me, please...?

Thank you.

rgds
js

 

[Ashish Mathur]

Hi,

Use the following formula in cell B2 of sheet2 (if the status is a numeric
field).

LOOKUP(99^99,Sheet1!B11:H11)

Use the following formula in cell B2 of sheet2 (if the status is a
non-numeric field)

LOOKUP(REPT("z",255),Sheet1!B11:H11)

Once you have used either of these formulas, just copy it down.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

 

[js]

Hi,
It's work. Thank you very much.

rgds
js

Hi,

Use the following formula in cell B2 of sheet2 (if the status is a numeric
field).

LOOKUP(99^99,Sheet1!B11:H11)

Use the following formula in cell B2 of sheet2 (if the status is a
non-numeric field)

LOOKUP(REPT("z",255),Sheet1!B11:H11)

Once you have used either of these formulas, just copy it down.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com