Anyone know of an easy way to separate the Row and Column values of a selected cell.
In other words, I have cell D4 and I'd like to be able to find a cell in column D of (whatever row value I choose) and a cell in row 4 of (whatever column value I choose).
Essentially, I'm wanting to do the opposite of the address function.
Thanks.
Welcome to the forum, jon.
Row(d4), column(d4)
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
This kind of thing is often done in a lookup table.
Take a look at this sample file, the Distances sheet has a two-dimensional lookup table. At the top you select a city in each of the city cells, and the intersection (row and column) is found. This can be accomplished with an INDEX/MATCH(row)/MATCH(col) or with a VLOOKUP().
Index-Match-Simple.xls
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks