Formula Help Plz

[Azhar Nadeem]

In the attached file have two parameters
1. Product Code
2. Minimum Loan Limit (Variable)

I am trying to match product code with minimum loan limit and output result as "Not Eligible for Rollover", "Ok to Proceed"

Help plz.

Regards

 

[p45cal]

This will give you the min. loan: in any cell:
=VLOOKUP($C$4,$G$5:$H$10,2,FALSE)
An example of an IF statement in one cell to give a text output:
=IF(C12>=VLOOKUP($C$4,$G$5:$H$10,2,FALSE),"This","That")

 

[vletm]

Azhar Nadeem
You give many possibilities...