View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
H/A[_2_] H/A[_2_] is offline
external usenet poster
 
Posts: 5
Default Refernce 2 sheets & same columns & rows



"H/A" wrote:

Is it possible to do the following...

Sheet 1
Sheet 2
A B C D A B
C D E F G H

2 3 5 5 4 7

1 1 1 1 1 1
80 A 61 2
8 1 # 61 3
6 B 61 4
4 2 62 5


Ok, Sheet 1 has alot of forumlas to get the #'s in Column A, what I am
trying or would like to do is formulate a chart in Sheet 2 C3:H6 that will
format the corresponding numbers from Sheet2 Col A&B and Row 1&2 and place
them in sheet 1 B3,b4,b5,&b6 and return the formulated number from D5 (D5
from sheet 1 is a formula using the numbers retrieved from the columns and
rows in sheet 2 and the columns and rows in Sheet 1....
For example on sheet 1 in the B column i want it to place 61(sheet2 A3) in
Sheet1 B3, a 2 (sheet2 B3) in sheet 1 b5... the C column in Sheet 1 is
referencing where the numbers come from from sheet 2.... so on and so
forth... but i want to do it for the whole sheet...

Is this possible... Does it even make sense?

Thanks



Ok, now that it has posted, it doesn't even look right on here.... isn't
there a site that i can upload my sheet and someone else can look at it????