Hi,

Please help me out with the forumla.

Help with the forumla, whether it works with vlookup or IF conditions

Group Invoice Age Amount
1 Retail 1 550
2 Retail 35 600
3 Retail 45 325
4 system 25 485

For EX: If (line# 2 = Retail)& if (invoice age <60 & 30), the result
should be amount i.e 600

Do the needful.