Index Look Up - Help a Newbie?

BrookeDawn

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.

Brooke Y

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

Brooke Y

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

BrookeDawn

that worked - i really appreciate you taking the time to answer this!