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!
@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?
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
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.
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!
@@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