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