Formula error

[pmteraiya]

I have bring value in two adjoining column

" Date " in column B by using

=VLOOKUP($C$2,'Work Completion Date'!$B$3:$L$354,2,0)

" Amount " in Column "C" by using

=IF(E28>0,IF(G12=1,Value!$C$57,IF(G12=2,Value!$C$76,IF(G12=3,Value!$C$81))))


and then I try use this results in other formula like
=IF(COUNTIF($L$28:$M$44,A99),VLOOKUP(A99,$L$28:$M$44,2,FALSE),0)

or

=IF(A101=VLOOKUP(A101,$J$28:$J$44,1),VLOOKUP(A101,$J$28:$K$44,2),0)

i get "#N/A" instead of result or sometime i get result for only first cell in column range

I have date form dd-mmm-yy. I tried by formatting cell to same date format but not solved

please reply

 

[Robert Mika]

Hi pmteraiya
Welcome to the forum,
Would you care to post some data?

In this formula:
=IF(A101=VLOOKUP(A101,$J$28:$J$44,1),VLOOKUP(A101,$J$28:$K$44,2),0)
you are missing the 4th parameter "Range parameter" unless you want to get the closest match not the exact

 

[pmteraiya]

Hi Robert,

Thanks lot for care to solve.

I have found mistake that date value was with time so the function result show error.

Once again Thank You,