- 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 ]














6 Responses to “Using Lookup Formulas with Excel Tables [Video]”
H1 !
this is my very first comment.
Can you use same technique with Excel 2003 lists ?
thanks 😀
Thanks, Chandoo! I like seeing the sneak peak of what's to come on Friday too 🙂
@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?
[…] Using Tables – Video 1, Video 2 […]
[…] Using Tables – Video 1, Video 2 […]
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.