# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i have a spread sheet , where i have row names a , b ,c and i have column names d, e, f, , , , , , in the table if i enter one , i want to get column name and row name , d a , e, b , f, c
Solved by E. S. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
User 10/04/2018 - 05:40
hi
User 10/04/2018 - 05:40
sir
Excelchat Expert 10/04/2018 - 05:40
Hi there
User 10/04/2018 - 05:40
sir are you able to see my sheet that i enter value
Excelchat Expert 10/04/2018 - 05:41
Yep
User 10/04/2018 - 05:41
ok sir , i want to get the result in another sheet , but my result should be like this ,
User 10/04/2018 - 05:41
the sheet
User 10/04/2018 - 05:42
if i enter 1 i want to get column name and row name
User 10/04/2018 - 05:42
you seen
Excelchat Expert 10/04/2018 - 05:43
yep
User 10/04/2018 - 05:43
if i enter value one or any letter depends on my task, i want to get row and column name
Excelchat Expert 10/04/2018 - 05:44
we can get column name as A, B, C and row name as 1,2,3
Excelchat Expert 10/04/2018 - 05:45
like you entered 1 we can get the output as C3
User 10/04/2018 - 05:45
c3 is the location of cell
Excelchat Expert 10/04/2018 - 05:45
yep
User 10/04/2018 - 05:45
i want to get the name
User 10/04/2018 - 05:45
b 22
Excelchat Expert 10/04/2018 - 05:46
getting the name like that is not possible in excel, as excel treat them as values in a cell location only
User 10/04/2018 - 05:47
ok according to you its not possible , but but is there is any option , to assign c3 location name as b22
Excelchat Expert 10/04/2018 - 05:49
This can be done using a VBA code/Macro
User 10/04/2018 - 05:49
ok ok ,, another question sir ,, if i have data see sheeet , i want only those name whose vlaue is this
Excelchat Expert 10/04/2018 - 05:50
Okay
Excelchat Expert 10/04/2018 - 05:52
Okay means by looking the alphabets you need to get the numbers right?
User 10/04/2018 - 05:52
i want to skip 0 value names
User 10/04/2018 - 05:53
only want to display those cells who has value
Excelchat Expert 10/04/2018 - 05:53
yah, got it
User 10/04/2018 - 05:54
any rule or formulla
Excelchat Expert 10/04/2018 - 05:54
Check there i have given you the formula :)
Excelchat Expert 10/04/2018 - 05:55
Is it nice
User 10/04/2018 - 05:55
i enter more data
User 10/04/2018 - 05:56
not displaying
Excelchat Expert 10/04/2018 - 05:56
put the alpabhets also in column D
User 10/04/2018 - 05:57
yes thanks
User 10/04/2018 - 05:57
sir
Excelchat Expert 10/04/2018 - 05:57
Please do a valuable rating for me
Excelchat Expert 10/04/2018 - 05:57
that will help me a lot
User 10/04/2018 - 05:57
sir can you mail me at shahidhost@gmail.com
Excelchat Expert 10/04/2018 - 05:57
If you really like it please put up some good words for me clicking "Others"
User 10/04/2018 - 05:57
ith vba macro code
Excelchat Expert 10/04/2018 - 05:57
User 10/04/2018 - 05:58
i am new here , i will do what ever screen show me
User 10/04/2018 - 05:58
thanks sir
Excelchat Expert 10/04/2018 - 05:58
Yep
Excelchat Expert 10/04/2018 - 05:58
Thanks for being in Got it Pro!
Excelchat Expert 10/04/2018 - 05:58
Have a nice day!
User 10/04/2018 - 05:58
sir can you mail me
User 10/04/2018 - 05:59
for more help in future
User 10/04/2018 - 05:59
User 10/04/2018 - 05:59
shahidhost@gmail.com

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.