DONT READ THIS Cause It Really Works. YOU WILL GET KISSED ON THE NEAREST POSSIBLE FRIDAY BY THE LOVE OF YOUR LIFE. TOMORROW WILL BE THE BEST DAY OF YOUR LIFE. HOWEVER IF YOU DONT POST THIS COMMENT TO AT LEAST 3 VIDEOS YOU WILL DIE WITHIN 2 DAYS. NOW UV STARTED READIN DIS DUNT STOP THIS IS SO SCARY. SEND THIS OVER TO 5 VIDEOS IN 143 MINUTES WHEN UR DONE PRESS F6 AND UR CRUSHES NAME WILL APPEAR ON THE SCREEN IN BIG LETTERS
#REF! just means that the reference that the INDIRECT is creating is not a true reference. You need to look closely at the Excel Defined Name and see what character you are missing.
My ref problem is that i have more than one thing i need to substitute. I can't figure out how to substitute them both when i try it either comes up with Error or VALUE so im not quite sure what Im doing wrong.
This is really an awesome trick, amazing! I've read "Microsoft Excel Data Analysis and Business Modeling" by Wayne Winston and it really helped me much in using and combining all the functions and I thought that's it, that's all I need! But your videos showed me tricks I've never even thought they exist. Many thanks for you sir.
There are an infinite number of things that Excel can do. That's what makes it so much fun. I have read about 30 Excel books and every one of them has new amazing tricks. If you want a systematic presentation of what I know, you can watch the Highline Excel Class Playlist. To see how to find Playlists and use the excelisfun channel efficiently, search for and watch this video title:
excelisfun Search For Excel Videos and Playlists & Download Workbooks
This sort of two way lookup (and INDEX & MATCH similar solutions) are for situations where you have variables along two axes. In the Lookup Video Series that I have posted at YouTube there are tax table examples that show an efficient use of the two-way lookup solutuion (VLOOKUP & column 3 would be a less efficient solution).
This has been flagged as spam show
DONT READ THIS Cause It Really Works. YOU WILL GET KISSED ON THE NEAREST POSSIBLE FRIDAY BY THE LOVE OF YOUR LIFE. TOMORROW WILL BE THE BEST DAY OF YOUR LIFE. HOWEVER IF YOU DONT POST THIS COMMENT TO AT LEAST 3 VIDEOS YOU WILL DIE WITHIN 2 DAYS. NOW UV STARTED READIN DIS DUNT STOP THIS IS SO SCARY. SEND THIS OVER TO 5 VIDEOS IN 143 MINUTES WHEN UR DONE PRESS F6 AND UR CRUSHES NAME WILL APPEAR ON THE SCREEN IN BIG LETTERS
TheReba436 1 year ago
This has been flagged as spam show
I have a question. what to do if I need to use substitute twice.
here is my formula and I still get #REF!
=INDIRECT(SUBSTITUTE(A147," ","_")) INDIRECT(SUBSTITUTE(B146," ","_"))
Thank you,
K
fastfreak123 1 year ago
I have a question. what to do if I need to use substitute twice.
here is my formula and I still get #REF!
=INDIRECT(SUBSTITUTE(A147," ","_")) INDIRECT(SUBSTITUTE(B146," ","_"))
Thank you,
K
fastfreak123 1 year ago
#REF! just means that the reference that the INDIRECT is creating is not a true reference. You need to look closely at the Excel Defined Name and see what character you are missing.
ExcelIsFun 1 year ago
My ref problem is that i have more than one thing i need to substitute. I can't figure out how to substitute them both when i try it either comes up with Error or VALUE so im not quite sure what Im doing wrong.
=INDIRECT(SUBSTITUTE(Y9,")","_")) INDIRECT(SUBSTITUTE(Z8,"(","_"))
thats my formula so far but I also want to substiture "(" in Y9 to nothing and ")" in Z8 to nothing too.
Is this possible?
xtriknina 1 year ago
If you explain your problem and give an example of the solution you want, you can send your workbook to:
excelisfun at gmail
and i will take a look.
ExcelIsFun 1 year ago
@ExcelIsFun Thanks. I sent you the email .. and then one with the proper sheet... thanks again.
xtriknina 1 year ago
I sent a solution to you by e-mail that uses 2 SUBSITUTES!
I'll make a video soon!
ExcelIsFun 1 year ago
This has been flagged as spam show
@ExcelIsFun
I have a question. what to do if I need to use substitute twice.
here is my formula and I still get #REF!
=INDIRECT(SUBSTITUTE(A147," ","_")) INDIRECT(SUBSTITUTE(B146," ","_"))
Thank you,
K
fastfreak123 1 year ago
Do you excel your video lists? there are so many! Like if you want to find one you just use the look up functions.
GeneralEclectik 2 years ago
To see how to find Playlists and use the excelisfun channel efficiently, search for and watch this video title:
excelisfun Search For Excel Videos and Playlists & Download Workbooks
ExcelIsFun 2 years ago
This is really an awesome trick, amazing! I've read "Microsoft Excel Data Analysis and Business Modeling" by Wayne Winston and it really helped me much in using and combining all the functions and I thought that's it, that's all I need! But your videos showed me tricks I've never even thought they exist. Many thanks for you sir.
SanadFeisal 2 years ago
There are an infinite number of things that Excel can do. That's what makes it so much fun. I have read about 30 Excel books and every one of them has new amazing tricks. If you want a systematic presentation of what I know, you can watch the Highline Excel Class Playlist. To see how to find Playlists and use the excelisfun channel efficiently, search for and watch this video title:
excelisfun Search For Excel Videos and Playlists & Download Workbooks
ExcelIsFun 2 years ago
I tried vlookup and column index number 3
givingstars 3 years ago
Dear givingstars,
Absolutely that will work!!
This sort of two way lookup (and INDEX & MATCH similar solutions) are for situations where you have variables along two axes. In the Lookup Video Series that I have posted at YouTube there are tax table examples that show an efficient use of the two-way lookup solutuion (VLOOKUP & column 3 would be a less efficient solution).
--ExcelIsFun
ExcelIsFun 3 years ago