Forum Discussion
Excel spread sheet help using a data base
I am setting up a spread sheet (sheet 1)that I want to automatically fill based on a data base (sheet 2). I tried using =vlookup but it does not seem to want to acquire the data.
sivakumarrj What I am trying to do is fill in sheet 1 with a lookup from sheet 2. If I put an FSA number in the form I want it to look up the information associated with FSA 4 on sheet 2 So if I put 280 in the FSA blank I want the information under name and club to fill in from the sheet 2 which I set up like a data base with all the FSA numbers listed with their info. Hopefully that made sense. Thanks
Sheet 2 data base.
| FSA# | Last Name | First | Club |
| 4 | Adams | Carol | Hawthorne |
| 5 | Adams | Charlie | Hawthorne |
| 153 | Bessette* | Dorine | Coronado-Mainland |
| 210 | Boskovitch | Mike | Parkwood Oaks |
| 220 | Bove | Corinne | Southern Palms |
| 280 | Burrell | Rich | Deland |
Sheet 1
1. NAME | FSA# | 280 | CLUB | |||
| NAME | FSA# | CLUB | ||||
| 2. NAME | FSA# | CLUB | ||||
| NAME | FSA# | CLUB | ||||
| 3. NAME | FSA# | CLUB | ||||
| NAME | FSA# | CLUB |
|
Have a look and it will solve your issue.
- I know what I want it to look like, how did you get it to automatically fill in the blanks....what is the formula?
- I want to thank every one for all your help. It turned out to be more complicated than could be explained over the internet. Very complicated for me to understand. This was the answer...
=VLOOKUP($B10,FSADB!$A$2:$D$564,2,0)