What's the max # of tail #'s you can have in any one spot? 2?
"Laws that forbid the carrying of arms...disarm only those who are neither inclined nor determined to commit crimes...Such laws make things worse for the assaulted and better for the assailants; they serve rather to encourage than to prevent homicides, for an unarmed man may be attacked with greater confidence than an armed man." - Thomas Jefferson, 1776
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)
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)
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!!!
"Laws that forbid the carrying of arms...disarm only those who are neither inclined nor determined to commit crimes...Such laws make things worse for the assaulted and better for the assailants; they serve rather to encourage than to prevent homicides, for an unarmed man may be attacked with greater confidence than an armed man." - Thomas Jefferson, 1776
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)
Should look like this. with formula ending in ))+3)
"Laws that forbid the carrying of arms...disarm only those who are neither inclined nor determined to commit crimes...Such laws make things worse for the assaulted and better for the assailants; they serve rather to encourage than to prevent homicides, for an unarmed man may be attacked with greater confidence than an armed man." - Thomas Jefferson, 1776
Comment