PHD’s Regular Blah #11

Share

Facebook
Twitter
LinkedIn
  • GOOD NEWS, my wife has finally come to US yesterday. I am so happy. It was sad being away from her on our first marriage anniversary. But finally she came, her journey was safe and uneventful.
  • Buy walmart shares if you can, now that I have shifted to a hotel bang in front of the giant store. I have been to the store 4 times yesterday alone and picked up stuff till my hands ached.
  • The potters have arrived few days back. I have ordered set of first 6 books on Amazon and already in to the series big time. I dont have anything new to say about the books. If you havent read them, may be you should try once, its a different experience.
  • Seems like loads of things are happening on market front. They crashed, went up again and seems like they are going to crash again. I made some hurried purchased during the recent crash, my losses arent significant now. The recession seems to here already, few Indian companies have started reducing salaries or worse still revoking the paid salaries. [I am already working in one :P], feels like such an exciting time to be living.
  • I am totally crazed up to start my own web business. Exploring few ideas like a craigslist for Indian metros etc. There is nothing much to loose, but so much to gain by doing this. I could learn firsthand the nitti-gritties of running a business, managing servers, users, optimization, databases, services and so much more. If you have some exciting ideas and looking for a crazy soul to partner drop me a mail.
  • Work moved to a cruise control mode. Most of the things have become normal now. Hopefully I would move to another project in the coming months.
  • Oh yeah, PHD crossed a remarkable milestone(or crossing), my site bandwidth limit for this month is almost over, thats a whopping 2000 megabites served to hungry PHD readers. Well done folks. Please bear with me while I figure out better ways to manage the site by reducing unnecessary images, heavy plugins etc. If you see the site down during the next few days dont panic. Just drop in again on Feb 1st.

[Bored at work? Read the earlier blah :1 , 2, 3, 4, 5, 6, 7, 8, 9, n ]

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

6 Responses to “Using Lookup Formulas with Excel Tables [Video]”

  1. Damian says:

    H1 !
    this is my very first comment.
    Can you use same technique with Excel 2003 lists ?
    thanks 😀

  2. Tom says:

    Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂

  3. Chandoo says:

    @Damian.. Welcome to chandoo.org. Thanks for the comments.

    Yes, you can use the same with Excel 2003 lists too.

    @Tom.. You have seen future and its awesome.. isnt it?

  4. Q.fg says:

    Hi, is there a vlookup formula for the second example (IDlist)? I used a similar formula to look up the ID for the person, but the reverse way (look up the person with the ID) comes up N/A.

Leave a Reply