if two cells data matched then show another cells information

[EWH]

Hi guys,

back again!

I have a spread sheet with a list of dates in one column that are shown weekly (ie every sundays date), lets call this A. and another culum that has every days date for the last few years, we will call this C. Column D had the information reflecting the weeks advertising (in a figure).

the information in column C is a sum of the weeks advertising - this is the information on want to show in column B.

I basically want to say that is the dates in both column A and C match then show the information from colum D in cell B.

please let me know if you need further clarification.

i tried this - =IF(L12:L999='Data-Visits-Adv'!B:B,+'Data-Visits-Adv'!H:H) and it returned FALSE.

thanks in advance

 

[GlennUK]

Your description doesn't make sense. If you are wanting to lookup a single value from column D where cells A and C match then do a VLOOKUP.