Excel Formula

Hi Expert,

I am using Match Function but I don’t know why result is coming as expected. See attached file - Sheet Calculation - Highlighted Yellow Section.


Thank You
Z-Score.xlsm
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
For Col I the result is correct as you started at A2
Start at A1 and you will get 140 with is the row that matches with value of I32

You have mixed between Row and Column the rest are ok

check the attached file.
gowflow
Z-Score.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Thank you Very Much.....
0
 
gowflowCommented:
In this version I added the translation of Column in letters maybe it is more handy.
Rgds/gowflow
Z-Score.xlsm
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Naresh PatelTraderAuthor Commented:
Thank You much this is what I needed, but there is some problem while column comes under A to Z i.e. 1 to 26 i.e. result shows @F. I don't know how come "@" come from. If you are interested further help me beyond this then Scoring Simplified or pls let me know how do I rectify "@" problem.


Thanks.
0
 
gowflowCommented:
yes for sure I will look at it and also while driving after posting the solution I will need to revise it if you have data in columns like ABC or ADX etc... 3 letters. Give me 1 hour will get back to you hv to go lunch.

gowflow
0
 
Naresh PatelTraderAuthor Commented:
ok awaiting for your response....thanks
0
 
Naresh PatelTraderAuthor Commented:
May be I will reply your post after 30 min as I on my way back to Home.


Thanks
0
 
gowflowCommented:
ok here it is. value of columns wether 1 digit 2 or 3 will come out correctly. To test it just put any sequence say ABC 20 XX in any column say AAF or BDK or M or FG and see if it comes out correctly.
gowflow
Z-Score.xlsm
0
 
Naresh PatelTraderAuthor Commented:
Sure I will , one more thing you are going to see my next question?
0
 
gowflowCommented:
If you can wait 1 hour before you post it for sure as I have to go take my kids to music or else for sure you will get help in here as Experts don't loose time to provide support. Your choice.

If you want my assistance I will drop a line as soon as I am back.
gowflow
0
 
Naresh PatelTraderAuthor Commented:
I prefer to wait but I had already raised the new question. Do you want me to delete that one.or you just drop one line in that question so no other will attend that question.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.