HELP WITH EXCEL SPREADSHEET

M

mayoslc

I have an Excel spreadsheet with 4 tabs. I have seen another spreadsheet
whereby you enter your social security number and it will populate for
example your commission amount. On this spreadsheet, there are no other tabs
so I don't where the financial information is coming? I am trying to recreate
this for another spreadsheet I am working on. Can someone please help?
 
R

Ragdyer

Don't forget that a single sheet has in excess of 250 columns and 65,000
rows, so there is a lot of room to "put" a datalist in an out-of-the-way
location, and then access it with simple Vlookup formulas.

If you're looking for help with lookup formulas, start at this link of Debra
Dalgleish, and then post back with any questions:

http://www.contextures.com/xlFunctions02.html
 
Top