Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cross referencing on tables
Hello
I am having difficulties with getting an answer from a table which requires a cross referencing system, e.g on the x axis I have numbers from 1-10 and the same on the y axis and when you say 2 down and 4 across I require the contents in that box to be displayed in another table. I am in no way an expert on excel, in fact a novice and they may be a simple and obvious solution, any help would be greatly appreciated. Rich B |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cross referencing on tables
Checkout the OFFSET() function in Excel Help. It does exactly what you want.
-- Gary''s Student - gsnu200748 "Rich B" wrote: Hello I am having difficulties with getting an answer from a table which requires a cross referencing system, e.g on the x axis I have numbers from 1-10 and the same on the y axis and when you say 2 down and 4 across I require the contents in that box to be displayed in another table. I am in no way an expert on excel, in fact a novice and they may be a simple and obvious solution, any help would be greatly appreciated. Rich B |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cross referencing on tables
Have a look at INDEX and MATCH in Excel Help - these are often
combined to give you what you want. Hope this helps. Pete On Oct 2, 9:34 am, Rich B <Rich wrote: Hello I am having difficulties with getting an answer from a table which requires a cross referencing system, e.g on the x axis I have numbers from 1-10 and the same on the y axis and when you say 2 down and 4 across I require the contents in that box to be displayed in another table. I am in no way an expert on excel, in fact a novice and they may be a simple and obvious solution, any help would be greatly appreciated. Rich B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross referencing with VLookup ? | Excel Worksheet Functions | |||
Cross-Referencing Across Worksheets | Excel Worksheet Functions | |||
Cross Referencing | Excel Discussion (Misc queries) | |||
Cross referencing | Excel Worksheet Functions | |||
cross referencing | Excel Worksheet Functions |