Cant get my head around this one

[soli87]

[TABLE="width: 461"]
<tbody>[TR]
[TD]18/12/2017
[/TD]
[TD]$
[/TD]
[TD]£
[/TD]
[TD]EUR
[/TD]
[TD]NOK
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Receipts
[/TD]
[TD="align: right"]680
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Payments
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]350
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Interco transfer
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]B transfer
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Other
[/TD]
[TD="align: right"]500
[/TD]
[TD="align: right"]3,000
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]19/12/2017
[/TD]
[TD]$
[/TD]
[TD]£
[/TD]
[TD]EUR
[/TD]
[TD]NOK
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Receipts
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]590
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Payments
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]350
[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Interco transfer
[/TD]
[TD="align: right"][/TD]
[TD="align: right"]50
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]B transfer
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Other
[/TD]
[TD="align: right"]500
[/TD]
[TD="align: right"]3,000
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]




Im trying to do a formula that displays the result of 18/12/17 and Receipts then return the value in the second column (i.e. $) or return the value in 3rd column (i.e. £) etc.
or
if its 19/12/17 and Other then return the value in the second column (i.e. $) or return the value in 3rd column (i.e. £) etc.

I just cant get my head round it on what sort of formula to use. not sure if an OFFSET type is required. any help would be greatly appreciated.
I have lots of periods for this, this is just 2 dates as an example, but the info to look up - headings and rows stay the same no matter what the date.

 

[alansidman]

Cannot determine what is in each column from your posting. Suggest you use one of the upload help programs described here -->https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html in the posting aids section.