Trying to search a column and match values

[Zxpq]

Hi,

First of all, I've tried a lot of fixes to get the two different date formats (column A saved as text and I can't get it to be a date) so I can match values from 2 columns. Basically what I want to do is match a date in column A with a date in column D, then use the value in E that corresponds to the date in D to multiply column B by E. I was trying to use the MATCH function and IF but I'm just completely lost now. I hope this description of what I'm trying to do makes sense. Or maybe there's just and easier way to do it that I don't see.

Thanks for the help!

[tim201110]

=DATEVALUE(A3) works

[BadlySpelledBuoy]

Difficult to know exactly what you need without some manually created examples, but the formula below in G3 and copied down might help you in the right direction:

Please Login or Register  to view this content.

The part in red multiplies the text date by 1 which coerces is into a date rather than text which you can then use int he lookup.

BSB

[Zxpq]

Both of those formulas both give me a #VALUE result. I put in some manually created examples. To clarify, I want column B and its corresponding date in A, multiplied by the column E for the same date.

[BadlySpelledBuoy]

I've applied the formula from post #3 to the attached.
Works fine for me and gives your expected results too.

BSB

[Zxpq]

It's working in the file you uploaded, this is great. Thanks so much for the help! I have about 700 lines of this to convert and I was starting to think I'd have to do it manually!

[BadlySpelledBuoy]

Glad I could help (and save you some time!)

BSB