PDA

View Full Version : Copy cell sheet2 in sheet 1



Audax
11-12-2008, 08:47 AM
Hi, I hope somebody can help me

I have 2 sheets...sheet #1 there is a table with 8 columns and 20 rows
In sheet #2 cell A5 has a 3 digits number which the first digit will represent the column of the sheet #1 and the others 2 digits will represent to the row of the sheet #1. Ex: If A5=612 means column 6 (Column F) and row 12 of the sheet #1.. I want to copy the value that is in this cell (F12) of the sheet #1 in cell B30 of sheet #2.

THANK YOU FOR HELP ME

Bob Phillips
11-12-2008, 08:56 AM
Use thgis formula in B30

=INDIRECT("Sheet1!"&ADDRESS(MOD(A1,100),INT(A1/100)))

Bob Phillips
11-12-2008, 08:57 AM
Or better still, use

=INDEX(Sheet1!A1:H20,MOD(A1,100),INT(A1/100))

Audax
11-12-2008, 09:11 AM
Thanks EL XID for your VERY FAST answer...I copy your solution but in b30 appears #VALUE! any idea? Thank you

Bob Phillips
11-12-2008, 09:47 AM
Is your first sheet actually called Sheet1? Which formula did you try?

Audax
11-12-2008, 09:53 AM
Thank you for continuing to try to help me
My first sheet is Sheet1 and the table is there, I used =INDEX(Sheet1!A1:H20,MOD(A1,100),INT(A1/100))

Audax
11-12-2008, 10:06 AM
Thank you XLD it's work you are the best