Vlookup Function About To Get Much Easier As “Relationships” In Excel 2013

Excel spreadsheets (.xls)

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials

Vlookup functions are difficult to understand initially and while they become very powerful once you do fully understand how to use them, I can tell you from the dozens of requests that I get every month that the concept remains very difficult to understand. Microsoft is trying to make life easier for users by changing the concept again. Here is the direct quote from CFO’s excel 2013 preview:

Relationships instead of VLOOKUP. If you add your worksheets to the pedestrian “Data Model” feature, you can use the Relationships icon to define that CustID in your million row transaction worksheet is related to CustNumber in your customer worksheet. Now, without doing millions of VLOOKUPs, you can create pivot tables from the data on both worksheets. Whether you’re sick of people who feel superior because they can do VLOOKUP, or someone who does VLOOKUP in their sleep, no one can argue that creating a relationship in 3 clicks is faster than waiting for a million VLOOKUPs to recalculate.

This might work although it will simply make other parts more difficult. I’m assuming that having the right column headers will become very important as Excel 2013 will try to guess how data interacts with each other. It will certainly be very interesting to see. I’m curious, do you expect to upgrade to Excel 2013 as soon as possible? I will certainly start moving soon although I do use cloud computing a lot more than I did just a few months ago so it will only impact my more complex spreadsheets. If ever you’d like to access a preview version, you can try going here.


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


302 Feedbacks on "Vlookup Function About To Get Much Easier As “Relationships” In Excel 2013"


Questo realmente mi ha fatto a. Ho finalmente capito sembrava essere possibile, quindi pazzo innamorato pensare Spirito e affari appartenevo insieme.= Non credo potevo espandere l’ soldi che non ho il momento migliore ora. = Sono in grado di capire come . per rendere davvero il tempo Per coloro che hanno pronto,. = Non sarò mai essere realmente pronto,Sconto Scarpe Nike Air Max.

Pantalone Polo Hombre

industry. Inside of the IICRC,Moncler Herre Jakker Salg, there are five acceptedmethodologies of both wet and dry cleaning. No matter she’ll have fun in it collectively friends or together with her sister,Botas de Futbol Nike Compra, your little angel has to be able to use her imagination and look into quantity of magic along with a land where the relationship is green,Nike Air Max Sko Kvinder, beautiful and well-disposed.


Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.