Refernce 2 sheets & same columns & rows

H

H/A

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
 
H

H/A

H/A said:
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
Click to expand...


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????
 
G

Gord Dibben

You have to provide the URL link that MediaFire gave to your uploaded file.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to print an A4 document to 2 A5s 0
Adding sequence numbers to paragraphs 0
Match and delete rows on two different sheets from reference numbers 4
Found few bugs in my daily routine of work in excel for MAC 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
Found few bugs in my daily routine of work in excel for MAC 0
How to Import Formatted text as new Slides in PowerPoint 0
Need some PWA help 0

Top