• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup with Sumif

S

Shabbo

Member
Daer Sir,
I wanted to lookup value with the help of helper column but getting NA due to amount is mismatched.
The reason for amount mismatched is in sheet1 amount is bifurcated and sheet2 amount in combined.
How can we apply vlookup with sumif.
example: please refer yellow highlighted sheet2 column 44 amount is Rs 40000/- where as sheet1 yellow highlighted in column 55 and 55 Rs 20000 and Rs 20000.
 

Attachments

  • 1149 advances help.xlsx
    66.1 KB · Views: 8
Shabbo
Your thread's title gives image of challenges with VLOOKUP and SUMIF-functions.
Later, You wrote about LOOKUP; those are different.
Where do You would like to use SUMIF-function?

Case #N/A
Why You use in D-column's formulas range_lookup-parameter as 0 (zero)?
If You would use it as TRUE, then You will get something else than #N/A.
Check VLOOKUP-formula's syntax.
 
You must log in or register to reply here.
Back
Top