I finally learnt the Two Way Search using XLOOKUP. It took me awhile but I did it plus some functions which I used for the first time through this interactive video.Thanks!

I'm going to go ahead and thank you before he video is even over. - Thank you

@LearnitTraining

9 ай бұрын

You are welcome!

You make learning easy and enjoyable.

@LearnitTraining

2 жыл бұрын

Thank you so much for the kind words Courage! Great name!

These tutorials are great. Keep up the good work!

@LearnitTraining

2 жыл бұрын

Glad you like them!

this was a really good tutorial. bravo!

@LearnitTraining

2 жыл бұрын

Glad it was helpful!

I love your style of teaching. I've watched many tutorials but always find myself stopping the video half way through because i dont like the style. Please keep making tutorials!

@LearnitTraining

3 жыл бұрын

Awesome, thank you!

Wonderful video. Thank you!

@LearnitTraining

2 жыл бұрын

Our pleasure!

jazak Allahu khairan, Faz. i love your videos

@LearnitTraining

3 жыл бұрын

Thank you for subscribing MD Samir Kabir! It means a lot to us!

@samirsvlogs3626

3 жыл бұрын

Thanks to you guys for your times which u spent for this costly videos to make us expert in excel. ❤️

thank you, learn a lot

@LearnitTraining

4 жыл бұрын

You are welcome!

Super useful!

@LearnitTraining

2 жыл бұрын

Glad it was helpful!

Fantastic FAZ

@LearnitTraining

2 жыл бұрын

Thank Sean for watching and an extra big thank you for subscribing!

@Learnit Training Faz, this was a great and helpful session . On your presentation you demonstrated the lock-up functions within one sheet, where all the datas are in one sheet. My struggle is to find someone showing and explaining vlook up and xlook up between 2 or more Excel sheets. Do you have that available?

@LearnitTraining

3 жыл бұрын

Awesome, thank you!

@aziquaderi

3 жыл бұрын

@@LearnitTraining you did not answer my question.

@blackwhite2361

2 жыл бұрын

@@aziquaderi🤣🤣🤣🤣🤣🤣. What he means is that your question is awesome 🤣🤣🤣🤣🤣🤣🤣🤣🤣

Thank you for the course provided. How do I sign in to the sharepoint to access & download exercise sheets?

@LearnitTraining

3 жыл бұрын

Hi Elaine - the link to the exercise files is in the video description

@elainestewart7188

3 жыл бұрын

@@LearnitTraining I see this, however, I am asking how to sign in.

Thanks for sharing it but I found it very confusing. First In your table for VLookup, I didn't know what did you mean by OLD? We were looking for value from the Gross Column. There was no mention of Gross and second, at 17:22 there was no explanation why did you assign value 1 for Gross Column/Array. (We are using this column as Array) You were talking about Array how it starts at 0 and then suddenly I am seeing 1,2,3, next to Gross columns. It really confused me. Not sure if I will watch the whole video. Thanks

Your videos have been helpful, thank you. I can't access the exercise file, it's showing that's it's broken

@LearnitTraining

2 жыл бұрын

Hi Adaeze! We just tested the link and it is working currently. Please be sure you are using a computer that can access Onedrive files

@adaezekatchy4341

2 жыл бұрын

@@LearnitTraining I've been able access the file now, thank you

I have 3 worksheets (tables) in a workbook). 1- Companies with 10 field including name, address, website, . 2- 2- Contacts with names, company names, title, phone number and email address. 3- Opportunities including names, address, etc. and companies which are working on any particular project and that is all. 4- Each sheet or table can have 100 to 10,000 records (Contact worksheet has the most) What I am trying to achieve is when selecting a company name (either from drop down box or...) see the records of all its employees and its opportunities if there are any also be able to edit or update the extracted values, if needed. Can someone help me by showing me how these can be done via VBA, or Power Lookup or any other means. I would appreciate it.

nice job. May i have the excel file, sir?

@LearnitTraining

4 жыл бұрын

bit.ly/2Pxt3Lq

Can you upload the exercise file ? thank you

@LearnitTraining

4 жыл бұрын

bit.ly/2Pxt3Lq

@francescotagliavento8081

4 жыл бұрын

@@LearnitTraining thank you

above formula not working in my excel sheet. how to activate in my system?

@adarshkulkarni9754

4 жыл бұрын

Check the version of Excel you have. It works on Office 365.

Is this full course of excel in your playlist after learn all your playlist can I get job in mis please tell me please

@adarshkulkarni9754

4 жыл бұрын

Having an experience of 4+ years, I would say, It's a part of excel and all the videos of Learnit are not sufficient to get job! You need to do the Excel certification. In addition to that if you could do Tableau or Power BI and Service now it will be an added advantage to get a job. Excel is most basic tool used in small scale industries. Good luck!

@francescotagliavento8081

4 жыл бұрын

in which field?

@adarshkulkarni9754

4 жыл бұрын

@@francescotagliavento8081 he is referring to MIS reporting field it seems.

@BharatSingh-lt5pz

4 жыл бұрын

@@adarshkulkarni9754 hey adarsh thank a lot for your reply and sharing knowledge ,. But can you tell me please from where I can get full course where I can get job in mis or I can learn all things in ms office like excel word and PowerPoint ,but if possible in cheap. Please please

@BharatSingh-lt5pz

4 жыл бұрын

@@francescotagliavento8081 mis field

11

The files is already completed and do not allow deletion of the fields.

@LearnitTraining

2 жыл бұрын

Hi Frances! You can download a local copy and make any changes you wish!

We can change #N/A with function if(isna(match(,,,)),"",match(,,,))

Xlookup replaced vlookup,index+match, vlookup+match, vlookup+match

I guest it only worked for Excel 2010, as 2016 didn't have for this fuction

@LearnitTraining

3 жыл бұрын

Hi Yoga this function was added just recently and works with Office 2019 or Office 365

@ominisxxx

3 жыл бұрын

Oh i thought so. Thank you for your information, i really appreciated for it

great video except for that blue bar at the top and bottom of the video.

@LearnitTraining

3 жыл бұрын

Noted!

Lomudi Ruben 8 years ago Logistics industry Matrix 2:7

no such thing as muscle memory... it is brain memory

@LearnitTraining

2 жыл бұрын

Noted!