Lookup returning duplicate values when there' a blank. Can it search in sequence

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

I'm trying to now but the file is too large. I'm just trying to remove information to reduce the file size without losing too much information to demonstrate the problem.

Can you not copy and paste a few rows to a new w/book as your picture is only 20-30-rows of data?

Thank you, that's worked. Original post updated with sample document.

There are inconsistencies on "Front Sheet" date (B2) and the days in row 4: change the date but it simply puts it in H4. So subsequent data (row 5 onwards) is out out sync.


Properly synchronised, a "lookup" under the date heading could extract the "name" i.e. 1008, 1013, 1204

This >=???

in C4 of "Front Page"

=IFERROR(VLOOKUP(B$5:B$25,Formulas!G$1:H$21,2,FALSE),INDEX($H$5:$L$25,0,MATCH($B$2,$H$4:$L$4,0)))

Hi John. It appears the sheet lost some of it's functionality when I pasted it to a new document. C1 on tab 2 is a dropdown on my original version allowing you to select the day of the week you want the sheets to populate for. When you change the day it pulls the data from the corresponding column on the front sheet for the day you select.
Column C of front sheet does not have any issues and pulls the correct data I am after.
I realise now that looking at it the pay numbers are very similar to the duty numbers so have changed them to letters instead to avoid any confusion.
I had also not changed the 1904 date system on the new document which is why the dates did not correspond to the formula table as they were 4 years out.
I have made the changes and added the document again.

In the example pictures above based on a Tuesday, B20 correctly reads 1008, B22 reads 1008 but should be 1013 which corresponds to I14 on the first tab and B23 should read 1204. It will then get the correct times from third tab.

Here is a link to the first thread where I had issues getting the date to pull through when there was no populated name.

HTML Code: