create a lookup table..

October 7, 2011 at 19:22:52
Specs: Windows Vista
I am given the asset size for 4 different banks. I need to create a lookup table that assigns each bank a category (A,B C, etc) based on asset size in $100 million increments.

NorthWest Bank = $30,000,000 in assets
Sunnyside Bank = $250,000,000 in assets
Crestview Bank = $101,500,000 in assets
Acorn Bank = $600,000,000 in assets

help please :)

See More: create a lookup table..

Report •

October 7, 2011 at 19:58:37
you need on work with excel using vlookup.

There are several good vidoes on youtube , that will definatel help you . I have myself worked with vlookup and hlookup after taking 10-15 minutes video guidance from youtube.

Just google : video tutorials on vlookup Youtube
and you get your tutorials.

Hope this helps you out


Report •
Related Solutions

Ask Question