YTL Excel #119: Amazing Lookup Solution!
Loading...
Loading...
17,962
Loading...
Uploader Comments (ExcelIsFun)
Video Responses
This video is a response to Excel Name Trick #7: INDIRECT function, Names and LOOKUP
see all
All Comments (14)
-
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
Loading...
6:37
YTL Excel #118: Form Controls Linked To Cellsby ExcelIsFun21,308 views- 5:19
Excel Name Trick #7: INDIRECT function, Names and LOOKUPby ExcelIsFun67,939 views
- 7:55
YTLE#67: VLOOKUP & DGET functionsby ExcelIsFun9,213 views
- 10:34
YTL Excel #126: VLOOKUP & INDIRECT & COLUMN functionsby ExcelIsFun12,854 views
- 7:34
Excel Magic Trick 606: INDEX & MATCH Two Lookup Valuesby ExcelIsFun16,269 views
- 6:38
Use the INDIRECT() Function to Create a 2nd Pick From List in Excelby DannyRocksExcels8,961 views
- 4:46
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookupby ExcelIsFun69,039 views
- 1:35
Excel lookup with multiple conditions! (extended vlookup)by Psychotec15,461 views
- 4:56
Excel Lookup Series #12: INDEX & MATCH functions Example 2!by ExcelIsFun42,389 views
- 7:58
Excel Lookup Series #1: VLOOKUP Function 1st Exampleby ExcelIsFun317,024 views
- 8:18
Excel Magic Trick # 254: Data Table Creates 100 Formulasby ExcelIsFun26,099 views
- 6:28
How to Merge Multiple Excel Workbooks to a Master Budgetby DannyRocksExcels41,052 views
- 4:27
YTLE#75: DV Drop-Down based on DV Drop-Downby ExcelIsFun8,162 views
- 6:34
Mr Excel & excelisfun Trick 16: Scroll Bar For Percentageby ExcelIsFun10,034 views
- 3:43
CHOOSE Function V2by AuditExcel1,254 views
- 8:19
Excel Magic Trick #505: INDIRECT function 2-Way Lookup Date Troubleby ExcelIsFun7,899 views
- 3:47
Excel Lookup Series #14: CHOOSE functionby ExcelIsFun27,324 views
- 9:44
Excel Magic Trick 557: CHOOSE function to lookup Formula or Function (2 Examples).by ExcelIsFun7,671 views
- 9:08
Excel Lookup Series #4 PART 1: VLOOKUP Function 4th Exampleby ExcelIsFun51,571 views
- 3:15
Excel Lookup Series #9: INDEX function 1st Exampleby ExcelIsFun57,439 views
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