Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array: Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) excelisfun: Names, INDIRECT function and the Space Intersector Operator in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values) YTL Excel #119: Amazing Lookup Solution! Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup Excel Name Trick #7: INDIRECT function, Names and LOOKUP Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup MrExcel’s Learn Excel #965 – Two-Way Lookup Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH
Way off the subject for this video, but is there a way for VB from visual studio to use formated excel documents as variable sources? For instance if i have a bunch of info i want to import for use in a program in visual studio. Can i use excel to help populate that database?
You are welcome!
I do not know. There maybe a way, try:
mrexcel[dot]com/forum
THE best Excel question site.
can you help if a person born on 14/3/1780 and dead on 12/3/1955. i tried to use the datedif function but return #value.
I do not know how to do that. Post to THE best Excel question site:
mrexcel[dot]com/forum
One thing is that people can’t live 250 years, and “14/3/1780 ” is not a date.
Hello Mr. excel.
I need to know how to convert numbers to dates again. eg. 40620 to be converted into date.
Also is there a sheet wherein i find solutions for all the formulas of excel 2007.
For Number into date, click cell, Ctrl + 1, on Number tab apply Date Number format.
or
to convert number to date as text use this formula:
=TEXT(A1,”m/d/yy”) where A1 has number.
@1002vicky
ooh my GOD your exellent i like you both thanks keep it up by Pakistan
I’m a very proficient user of Excel. What these guys are doing is nothing short of brilliant. Genius at work.
I’m a very proficient user of Excel. Your instructional videos are nothing short of brilliant. What a joy to learn from you both, and Thank You!
I am glad that you like the video!!!
One of the very best channels…Learn a ton from you guys. Thanks
I am glad that the videos help!
great video!
You are welcome!
I had a similar problem to solve recently on a multiple foreign exchange rate conversion but couldn’t get the match to work. I used a VLOOKUP with a MATCH embeded to find the respective FOREX rate by specifc date within a FOREX by month table. Thanks for the tips.
Hi Mr Excel thanks for your videos there are all great. I have some questions for for you. Is it possible to make a pop up calendar in MS Excel 2007? If so could you make a video about this? Or do you have a DVD that I can purchase to learn how it is done?
hi mr excel,i am fresh graduate who is desirous of pursuing a career in finance,i am novice in excel and need your help.my email:carous_g2000@yahoo.com
just love your videos…you have to open your own excel school.. you are such a great teacher!!!!!!!!!!!!
@lera5266 , YouTube is the school! I am glad that you like the videos!
You guys can control the government
plz type you site address where from i can take that sheet and practice
@ssilentwish , Here:
people.highline.edu/mgirvin/ExcelIsFun.htm
awesome vid, i never knew how to use vb like user forms…..is there any other turotials on using vba user forms?
@Gbell3587 , Search Bill Mr Excel Jelen YouTube site, he has a few videos about User Forms:
.youtube [dot] com/bjele123