Vlookup query with IF, AND and possibly any other commands

0

I've prepared a table in which I need to have a vlookup function to manage multiple criteria based on data in corresponding cells & sheets.

I need help to implement the following rules:

SHEET 1: Sheet 1 • I need data in column N to auto fill as per below criteria:

a. Completed – when date in entered in column L

b. Pending – If supplier payment term is “CREDIT” and date in column M is blank

c. Advance – if column L is blank and supplier payment term is “Advance”

SHEET 2: Sheet 2 • I need data in the following columns to reflect:

  1. Column H:

a. Reflect “completed” if column I is filled with a date

b. Advance/Credit if column I is blank

  1. Column K:

a. Reflect Pending/Completed depending upon date entered in column J

SHEET 3: Payment Terms Payment Terms

Rachan Dsouza

Posted 2019-02-10T09:25:37.020

Reputation: 13

What attempts have you made trying to build your IF() statements with VLOOKUP() results? – Chris Rogers – 2019-02-10T10:24:34.140

@ Chris Rogers: I have the following formulas applied: 1. =IF(L2<>"","Completed","Advance") - in column N of sheet 1, 2. =IF(I2<=TODAY(),"Completed",VLOOKUP(C2,'PAYMENT TERMS'!A:B,2,FALSE)) - in column I of sheet 2, 3. =IF(J2<>"","Completed","Pending") - in column K of sheet 2 – Rachan Dsouza – 2019-02-10T10:31:02.687

No answers

Asked: 2019-02-10T09:25:37.020

Viewed: 38 times

Active: 2019-02-10T09:25:37.020