LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Return a value from a table using Column and row names as input?

What cellformula, using column and row names, return a specific value from a
table like below? (I cant use the INDEX function since I dont know the column
or row numbers in the actual table, only the names)

A B C D F

1 Week 42 Week 43 Week 44 Week 45
2 Company 1 67% 71% 69% 81%
3 Company 2 45% 78% 79% 73%
4 Company 3 88% 67% 86% 74%
5 Company 4 97% 56% 77% 92%
6 Company 5 87% 55% 82% 69%





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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



All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"