Hi, I am trying to do a lookup based on 2 values matching, ive tried numerous formulas (index, match, sumproduct) etc but cant get it to work as im looking up text data.
I have a row of data across the top
e.g. Barnet, Cheltenham etc
I have a column of dates along the side
06/08
20/08
etc
I then want to lookup column 7 in another worksheet but only if column 1 matches my row of data (e.g. Barnet) and Column 2 matches my column of data (e.g. 06/08)
Can anyone help me please!!!!
I have a row of data across the top
e.g. Barnet, Cheltenham etc
I have a column of dates along the side
06/08
20/08
etc
I then want to lookup column 7 in another worksheet but only if column 1 matches my row of data (e.g. Barnet) and Column 2 matches my column of data (e.g. 06/08)
Can anyone help me please!!!!