retrieve data from another sheet based on date

[woody565]

Hi all,

I am struggling to find an answer to help me achieve what I want on a spreadsheet.

The data I want to be automatically populated is on another sheet within the same workbook. The 1st picture below shows catch returns for fish, including the date they were caught (in the green box). I would like the corresponding river height to be brought across from another sheet based on the date into the red square.
Catch returns.png

The River height is on another sheet
River heights.png

I want to end up with it looking like this with the new data added on the right, is this possible with formula? as there is 1000s of entries so doing it manually would be painfull!
end result.png

Many thanks for and help or advice

[maniacb]

you should be able to bring over the river height reference base values with a VLOOKUP formula. If you provide a small sample of data as per the yellow banner above it couldbe easily accomplished. as a guess, it should be something like

Please Login or Register  to view this content.

for column P, and then the 2 changes to 3 in column Q and 4 in column R

[woody565]

Thanks very much for the help, I will have a look at the recommendation above.

I have also added a sample workbook.

[maniacb]

I hope this works for you. Happy fishing

[woody565]

Thanks very much, I have just tried the solution you provided and it works to some degree, I am sure its down to the way I have implemented the formula.

After line 360 the river levels cell displays N/A and I cant work out why?

I have attached another example showing the N/A

Many thanks for your help

[Fluff13]

How about
In O2 filled down & across
=INDEX('Dee - Manley hall'!B$2:B$2094,MATCH($C2,'Dee - Manley hall'!$A$2:$A$2094,0))