Forum Discussion

Copper Contributor

Apr 27, 2022

Formula to pick up location data within multiple worksheets

Good afternoon, I am trying to create a formula where a cell contains location details for example, NSW - Crows Nest, and VIC - Flinders Lane - and have NSW or VIC populated in another cell. So the ...

Formulas and Functions

Gold Contributor

Apr 28, 2022

Kinda hard to "see the attached file" when the link takes one to this

Ange2010
Copper Contributor
Apr 28, 2022
mathetes my apologies for that.
https://1drv.ms/x/s!AlpeZbby5IYVqWef7qfirpsxbREw?e=qjhqD7
- mathetes
  Gold Contributor
  Apr 28, 2022
  Ange2010
  
  It was a usable link, for which I'm grateful. Still was "read-only" however, so I copied some of the data to the attached and think I've done what you were wanting to do. Write back if not. The second sheet makes use of the FILTER function , which requires the most recent version of Excel.
  EducCalendarFIltered.xlsx15 KB
  - Ange2010
    Copper Contributor
    Apr 28, 2022
    mathetes thank you very much. When I used your formula in sheet 1 (National) in my master file (link below), it worked perfectly.
    My master file, sheet 1 (National) is pulling data from another workbook. For sheets 2-5, I was initially thinking I would have a sheet per State as our objective is to have a user friendly By State document to upload. Could I use a FILTER function here? If so, I would need assistance please.
    
    https://1drv.ms/x/s!AlpeZbby5IYVqWm4kBtyI15dOamq?e=2nLNZJ

Resources