Index Look Up - Help a Newbie?
![BrookeDawn](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Hi trying to write a very basic INDEX/MATCH formula to look up the ballpark name and ballpark address from ST Addresses and insert into Arizona Schedule. My formula is saying "no match". What am I doing wrong?!
This is my formula below
=INDEX({ballpark name}, MATCH(Team@row, {Ballpark}, 0))
– writing the formula here to have the team name and address pop up in yellow cells.
Best Answer
-
Hi BrookeDawn,
I'm assuming you are using the 'reference another sheet' link in your formula? I don't see the reference names in the formula you copied in. This is what one of my formulas looks like where I am pulling the clinic name in based on the address.
=INDEX({column in another sheet you want to pull in}, MATCH(cell in row you want to match,{column in another sheet you want to match against}, 0), 0)
Hope this helps.
Brooke
Answers
-
Hi BrookeDawn,
I'm assuming you are using the 'reference another sheet' link in your formula? I don't see the reference names in the formula you copied in. This is what one of my formulas looks like where I am pulling the clinic name in based on the address.
=INDEX({column in another sheet you want to pull in}, MATCH(cell in row you want to match,{column in another sheet you want to match against}, 0), 0)
Hope this helps.
Brooke
-
that worked - i really appreciate you taking the time to answer this!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!