I have a spreadsheet I have been working on.
I finally have a working solution, but with two issues.
First, the line is horribly long. I would love to be able to shorten this line so it isnt so cumbersome.
Second, there are a lot of #VALUE! errors. I would like to make these go away as well.
I have attached the sample spreadsheet.
The solution I came up with/stole/borrowed/modified is:
I currently have this pasted through sheet Po, F3 through F103.
What this should do is look at the value in the corresponding row. Then find that value on the Key sheet in Column A. The first part will use the value in that row, first column. It will look for that value on the schedule sheet and return the date only if it is found. Rinse and repeat for 6 total rows.
If there is an easier / better way to do this I am certainly open to ideas.
If there is a way to get the errors to go away, that would be great as well.
Thanks,
Anthony
Bookmarks