artland

Posts: n/a

How do I reference one cell in a table by using both the row and .

If I have a table with column headings and row headings that are different
and I want to find out the information for a particular cell based on what is
in those headings, how would I do that. i.e. if I had columns marked 1-10
and rows labled 2005 - 2010 how would I find the information of the cell that
matched column 6 and row 2008?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Maintaining cell reference after sorting	GRITS	Excel Discussion (Misc queries)	2	April 30th 23 07:42 PM
Cell Reference Math	Ralph Howarth	Excel Worksheet Functions	0	January 26th 05 06:27 PM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM
name of another worksheet in cell for reference	Tom A Johnson	Excel Worksheet Functions	2	November 11th 04 11:28 PM
cell reference show cell name (ie. D45) and not cell value	ria	Excel Worksheet Functions	4	November 6th 04 04:38 AM

All times are GMT +1. The time now is 08:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us