Need to return a value based on serial number and most current entry for that serial number by date

[Kenair]

Hi,

First post, I'm Stuck on something that seems should be simple.

3 columns Sheet 1
Column A: Dates beginning 1-Dec-15 through 31-Dec-20

Column B: Serial numbers of equipment used per day. Many empty spaces below current date. Filled in daily. Same with column C.

Column C: Status of the equipment for that day.

Need to display on sheet 2

Most current status of equipment by serial number. If equipment wasn't used today need the last status entered for that serial number to be displayed as current status. I have tried Vlookup, and Index Match with no luck. I'm completely stuck. Any help is greatly appreciated.

Ken

 

[hiker95]

Kenair,

Welcome to the MrExcel forum.


We would like more information. Please see the Forum Use Guidelines in the following link:

http://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[Kenair]

From my work station I have no peer to peer ability to access a Dropbox or install any programs to my computer. Im attempting to get an image uploaded to a url I can share.

 

[Kenair]

 

[hiker95]

Kenair,

In your reply #4 you have displayed an image?

Anyone trying to help you would have to enter the data manually.


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


If you are not able to provide the above, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[Kenair]

Kenair,

In your reply #4 you have displayed an image?

Anyone trying to help you would have to enter the data manually.


See reply #2 at the next link, if you want to show small screenshots, of the raw data, and, what the results should look like.

http://www.mrexcel.com/forum/about-board/508133-attachments.html#post2507729


Or, you can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com


If you are not able to provide the above, then:

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

Yes, Like I said I cannot access drop boxes or install programs on this computer due to the security setting our unit imposes. I have tried all the links in the rules and every site is blocked so I'm stuck with uploading a screen shot to a url and linking to that url. Sorry.

 

[Kenair]

2-Dec-15	20199	FMC
2-Dec-15	21114	FMC
3-Dec-15	21100	FMC
3-Dec-15	20199	FMC

<colgroup><col width="166" style="width: 125pt; mso-width-source: userset; mso-width-alt: 6070;"> <col width="83" style="width: 62pt; mso-width-source: userset; mso-width-alt: 3035;"> <col width="87" style="width: 65pt; mso-width-source: userset; mso-width-alt: 3181;"> <tbody> </tbody>

 

[hiker95]

Kenair,

Your reply #7 is a partial flat text display for Sheet1?

What about Sheet2?

 

[Kenair]

never mind guys.. when I cut and pasted that text from spread sheet It effected my excel based on our restrictions and my computer ended up in IT for 6 hours. Ill just continue to work the equation myself.