Display last status information

J

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
 
A

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
 
J

js

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

rgds
js

Ashish Mathur said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top