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.
Try to use Indirect formula with link
A2 B2 C2 D2 E2
A3 B3 C3 D3 E3
A4 B4 C4 D4 E4
A5 B5 C5 D5 E5
A6 B6 C6 D6 E6
Sheets Sales Tyres Tubes Spares Service
Sheet2 20 4 7 6 10
Sheet2 16 11 8 2 20
Sheet2 17 17 2 2 18
Sheet2 11 10 12 8 2
Sheet2 15 15 8 4 18
Formula is =INDIRECT("'"&$A7&"'!"&B1)
It indirectly link with sheet with data by reference.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.
- Attach a sample workbook. Show your input and desired output. Explain in brief what you want.
