• 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.

if then lookup

Shabbo

Member
Dear Sir,
I wanted to apply formula like,
I wanted to lookup Invoice value in Sheet 1 Column (F) from sheet 2 in column E
I wanted to lookup Invoice Name in Sheet 1 Column (D) from sheet 2 in column C

IF THERE IS TDS RECEIVABLE IN COLUMN D THEN FORMULA SHOULD BE SUM OF INVOICES AFTER TDS RECEIVABLE MINUS LOOK UP VALUE FROM SHEET 4 COLUMN B LOOKUP REFERENCE SHOULD BE SHEET1 COLUMN N
 

Attachments

  • 19-03-2020.xlsx
    21.5 KB · Views: 2
Back
Top