Sep 22 2022 05:12 PM
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.
Sep 22 2022 06:51 PM
Sep 22 2022 10:57 PM - edited Sep 22 2022 10:58 PM
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.
Sep 23 2022 04:30 AM
@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 |
|
Sep 23 2022 08:24 AM - edited Sep 23 2022 08:25 AM
Have a look and it will solve your issue.
Sep 23 2022 10:10 AM
Sep 25 2022 09:59 AM