Hi,
I have the following data on another tab that is refreshed.
Test.xlsx
I need to be able to change the Code/Date on cells B14/B15 and have the close numbers come up.
I thought that I would be able to do it with a index/match 2 way lookup but the problem is when the data is missing for dates which causes the row to break.
Does anyone know of a code that would work?
I tried the following formula: =INDEX(A1:K7,MATCH(B15,B3:B7,0)+2,MATCH(B14,A1:K1,0)+1) however when you try using it on IA0001 it wont work due to missing data. Is there any work around?
Bookmarks