Hi all
I need a bit of help with an IF/VLOOKUP formula.
I have two tables in separate workbooks - hundreds of enteries per table. I have simplified the data and put both tables on one sheet for ease on the attached.
I am trying to put the stock value from table 2 (Col K) into table 1 but only if the code and date match in table 2.
Formula I've been trying is:
(In B4) =IF(AND(J5:J19=A4,L5:L19="28/12/2015"),VLOOKUP(A4,J:K,2,0),"NIL")
What I was hoping to achieve is shown on the attached.
Any help would be greatfully received.
Bookmarks