Hi there, is it possible to v lookup in rows rather than in cols. I have attached an example of what I am trying to do... In B9 I want to populate the number below that is below the date in row1 that matches the date in A9. So if the data in A9 was 29/06/2017 then it would return 232 as that is the number below the date in the table.
Its almost like B9=Vlookup,A9 in Row 1 and return the value below in R
Hope this makes sense
Scott
Bookmarks