Vlookup query - looking up from a horizontal table to deliver numbers to a vertical table

Hello,

I have a table (see attached) where there is a horizontal table with two date rows and a row showing the number of units of equipment.

I have a second table that is the same as the first table, but it is vertical.

I am trying to drop the number of units from the horizontal table next to the corresponding date in the identical vertical table.

Would anyone be able to help with this? I believe I may need to use a combination of Vlookup and Hlookup, but my attempts have been unsuccessful.

Any help much appreciated.

Many thanks!

Hi Jeff,

I am sure this is my mistake, but when I copy the cells down and across it gives the same values in column F.

Columns G to BM have #N/A.

Any ideas wha

I am trying to have the units in row 3 correspond to the correct date vertical and horizontal date reference.

So, for example the 3 units in P3 would get dropped into cell P15 (lining up with the vertical and horizontal date of 1/11/17.

Is that possible?

Hi Jeff,

In this file all the numbers are going down column F, but it returns 0's to the other columns. What I am trying to do is have one value only returned to each column. Because each number with be aligned with the same date (from the vertical and horizontal axis) the numbers will be perfectly diagonal from top left to bottom right.

Do you know what I mean? I could do it manually, but I will need to change these numbers and therefore need to automate it.

Many thanks,
Adam

Try this in F5:

=IF(AND(F$1=$D5,F$2=$E5),F$3,"")

That works Phuocam!

Thankyou very much to everyone for helping me with this.

All the best!