Excel 2007 : #VALUE using multiple IFs

[A Jackson]

I am trying to create a formula that looks to a different worksheet at 3 different date cells, picks the most recent date and enters the $ value from the specified cell for the resultant date. I keep getting #VALUE. I have put all 3 date cells in date format yyyy-mm-dd and all 3 $ value cells in currency format. I am using IF function but I'm pretty sure I'm doing something wrong. Can you help please?

[TMS]

You might want to upload a sample workbook ... I know I'm lacking imagination but you leave a lot to guess at. What is the formula? What data is in the cells?

It doesn't really matter how you format the cells, if it's a data, it's a number; if it's currency, it's a number.

If you're getting #VALUE!, there's a problem with your data.

Regards

[A Jackson]

Here's what I'm trying to do in cell N2 on the Matrix worksheet: N2 looks to M2 (calculated by =MAX(VLOOKUP(K2,PriceList!A2:W193,9,FALSE),VLOOKUP(K2,PriceList!A2:W193,10,FALSE),VLOOKUP(K2,PriceList!A2:W193,17,FALSE)) for a date result. Then i want to find that date result on the PriceList worsheet and enter a $ amount from another cell on that worksheet. I'm trying to do that with: IF(M2=PriceList!I2,PriceList!C2),IF(M2=PriceList!J2,PriceList!K2),IF(M2=PriceList!Q2,PriceList!R2). There are 3 date cells in the first formula and this calculates properly with a date result. There are the same 3 date cells as well as 3 number cells in the second formula. Result is #VALUE. All number cells are formatted to currency.

Hope this helps a little more
thanks

[TMS]

Try:

=IF(M2=PriceList!I2,PriceList!C2,IF(M2=PriceList!J2,PriceList!K2,IF(M2=PriceList!Q2,PriceList!R2,"Not Found)")))


Regards