formula returns VALUE error

[mkmed]

Hello,

The following formula returns a VALUE error when true and I can not figure out why. If it matters, the criteria cell is a data validation list box.

Here is the formula:

=SUM(IF(E5="","",VLOOKUP(Estimate!E5,Crews!$AK$5:$AM$23,3,)))*H5

Any help is greatly appreciated.

Mark

[benishiryo]

hi Mark, it would be good if you can upload a sample Excel file. my guess is that you have to go inside the formula & press CTRL + SHIFT + ENTER if you havent already. but it's hard to guess

[:) Sixthsense :)]

Error Part of your above formula

Please Login or Register  to view this content.

This error has caused due to performing calculation with text value.

Either H5 Or the result of VLOOKUP(Estimate!E5,Crews!$AK$5:$AM$23,3,) is the text Number or Text Data.

---

Sixthsense

[mkmed]

I got it. The formula had a structure error. Corrected is as follows:

=IF(E5="",0,VLOOKUP(Estimate!E5,Crews!$AK$5:$AM$23,3,))*h5)

Thanks for looking