what info are you going to input?
i'll assume its a state and a town/city and you want the % then
=INDEX(INDEX(Sheet1!$A$4:$BW$170,,MATCH($B$1,Sheet1!$A$1:$BW$1,0)+1),MATCH(C1,INDEX(Sheet1!$A$4:$BW$170,,MATCH($B$1,Sheet1!$A$1:$BW$1,0)-1),0))
where b1 has a state name and c1 has a name of a town/city in that state
Last edited by martindwilson; 01-07-2014 at 10:16 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
this sounds like it will do the trick! ill check the formula tomorrow and let you know the results. thank you so very much!!
Are you trying to merge all of the tables into one? Ex. Have a column for state,city,and population all in one?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks