Simple problem:
a1 = "A"
a2 = "3"
a3 = "bunny"
a4 = tell me what formula or syntax I need to combine cells a1 and a2 to reference cell a3 and return the word "bunny".
I can't function today, help me out.
Simple problem:
a1 = "A"
a2 = "3"
a3 = "bunny"
a4 = tell me what formula or syntax I need to combine cells a1 and a2 to reference cell a3 and return the word "bunny".
I can't function today, help me out.
=indirect(a1&a2)
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Paste this in A4 - =INDIRECT(A1&A2)
Cheers!
Deep Dave
thanks guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks