Vendor Credit Rating

[Excel_Pa]

Hi All,

Please help to get the formula to auto populate the credit limit of vendors.
I have attached the xls for your reference. I have do this for many entries and it consuming lot of time.

Thanks in Advance

[JohnTopley]

in D2 and copy down

=INDEX($G$3:$I$4,MATCH($C2,$F$3:$F$4,0),MATCH($B2,$G$2:$I$2,0))