|
Page 1 of 1 |
Horrordee
Soderator
Posts: 8849
Location: England
|
Posted: Thu, 24th Feb 2011 16:35 Post subject: Excel help! (transpose not working?) |
|
 |
I have this formula in cell A1:
=HLD!F$1&"="&VLOOKUP(HLD!F$1,HIDDEN_LOOKUP!$A$2:$C$307,2,FALSE)&INDEX(HLD!F:F,$C$3)&VLOOKUP(HLD!F$1,HIDDEN_LOOKUP!$A$2:$C$307,3,FALSE)&";"
Which works fine. I can drag it to the right and cell A2 looks like this:
=HLD!G$1&"="&VLOOKUP(HLD!G$1,HIDDEN_LOOKUP!$A$2:$C$307,2,FALSE)&INDEX(HLD!G:G,$C$3)&VLOOKUP(HLD!G$1,HIDDEN_LOOKUP!$A$2:$C$307,3,FALSE)&";"
However, if I copy those two cells, and paste them into B1 with "tranpose" ticked, the code in the INDEX function breaks! Cell B1 code is:
=HLD!F$1&"="&VLOOKUP(HLD!F$1,HIDDEN_LOOKUP!$A$2:$C$307,2,FALSE)&INDEX(HLD!#REF!,$C$3)&VLOOKUP(HLD!F$1,HIDDEN_LOOKUP!$A$2:$C$307,3,FALSE)&";"
And cell C1 code is:
=HLD!G$1&"="&VLOOKUP(HLD!G$1,HIDDEN_LOOKUP!$A$2:$C$307,2,FALSE)&INDEX(HLD!#REF!,$C$3)&VLOOKUP(HLD!G$1,HIDDEN_LOOKUP!$A$2:$C$307,3,FALSE)&";"
Can anyone see why?!?
If I manually cut the cells, and paste they work. It would seem transposing stuff within an INDEX function breaks it?
It's also weird because the code in green isn't effected, and pastes as you'd expect (aka doesn't change).
Space for rent. Contact me for rates!
|
|
Back to top |
|
 |
|
|
Back to top |
|
 |
Horrordee
Soderator
Posts: 8849
Location: England
|
Posted: Thu, 24th Feb 2011 16:49 Post subject: |
|
 |
That doesn't work within the function INDEX - i get an error...
Does that mean I'm fucked?
Space for rent. Contact me for rates!
|
|
Back to top |
|
 |
|
Posted: Thu, 24th Feb 2011 17:01 Post subject: |
|
 |
|
|
Back to top |
|
 |
Horrordee
Soderator
Posts: 8849
Location: England
|
|
Back to top |
|
 |
Page 1 of 1 |
All times are GMT + 1 Hour |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group
|
|
 |
|