LinkBack URL
About LinkBacks
I need a formula for writing numbers in certain cells.
In the right side of the red line, on the second row, I want to write some letters and I need the correspondent numbers to appeare above them, as in the picture2.
Thanks for your help!
I need a formula for writing numbers in certain cells.
In the right side of the red line, on the second row, I want to write some letters and I need the correspondent numbers to appeare above them, as in the picture2.
Thanks for your help!
Formula:
Please Login or Register to view this content.
Please click the * icon below if I have helped.
I'm not sure that I can understand how to use that formula. Can you tell me more, please?
Thanks a lot!
Hi and welcome to the forum
Next time, please dont upload a pic of your sample file, upload the actual sample file. Most members are dis-inclined to retype your data for you
Having said that, try this. I shortened the range, so you will need to textend it...
=INDEX($A$2:$J$2,1,MATCH(K1,$A$1:$J$1,0))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for that formula, but Excel is saying that it contains an error
Actually, I think that is possible to have a bug or something, because all the time I type a formula and press "enter", nothing is happening. I use Offie 2007, and my system is XP. Do you tkink there may be a conflict?
What I've found: the formula =IF(F2=A2;"1";IF(F2=B2;"2";IF(F2=C2;"3";IF(F2=D2;"4";IF(F2=E2;"5"))))).......... works!
How can I abbreviate it?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks