Excel guru needed

[BlackGT]

Ah, I see now.

What's the max # of tail #'s you can have in any one spot? 2?

[Nash B.]

Alright I entered it just like this and got the #N/A error

=INDIRECT("STATUS!B"&(MATCH(11,STATUS!B6:STATUS!B8 6,0))+4)-1

Try putting the parking spot in quotes (I'm thinking it's a number stored as text, so 11 and "11" aren't the same) and drop the -1 on the end (the offset is already accounted for with +4 instead of +5)

=INDIRECT("STATUS!B"&(MATCH("11",STATUS!B6:STATUS! B86,0))+4)

[BLK306]

Ah, I see now.

What's the max # of tail #'s you can have in any one spot? 2?

1 tail number per parking spot.

[BlackGT]

Try putting the parking spot in quotes (I'm thinking it's a number stored as text, so 11 and "11" aren't the same) and drop the -1 on the end (the offset is already accounted for with +4 instead of +5)

=INDIRECT("STATUS!B"&(MATCH("11",STATUS!B6:STATUS! B86,0))+4)

This is correct format. Have to wrap "" around the sheet name, but sheet name has to begin with ' and end with '!
=INDIRECT("'Tail # & Parking Spot'!B"&(MATCH(1,'Tail # & Parking Spot'!B6:'Tail # & Parking Spot'!B86,0))+4)

This should get you what you need!
Good Job Nash!!!

[BLK306]

Try putting the parking spot in quotes (I'm thinking it's a number stored as text, so 11 and "11" aren't the same) and drop the -1 on the end (the offset is already accounted for with +4 instead of +5)

=INDIRECT("STATUS!B"&(MATCH("11",STATUS!B6:STATUS! B86,0))+4)

That just has it coming back with a value of 0.

[Nash B.]

Ah, change +4 to +3 because you've got the merged cells.

[BlackGT]

Should look like this. with formula ending in ))+3)

[Nate]

Nassty Nate knows his way around excel.

Shhh don't tell anyone.

Nash b covered it just fine.

[BLK306]

Ah, change +4 to +3 because you've got the merged cells.

That got it! Thanks