Other potential titles: The US Embassy Doesn't Want You Know About This Kidnapping in ManilaScopolamine / Devil's Breath Trip Report
It started Easter weekend This story starts at Noon Tuesday April 18th, 2017 on Makati Avenue. I just finished a meeting with the Philippines Board of Investments to discuss how my company can expand our business in Manila. (Also saw the QBO Innovation Hub, it was awesome.) I had plenty of time to kill and some emails to catch up on, so it's time for some brain food!
I walked right to the hottest part of town, Makati Ave. and Jupiter Ave., surely there will be something good to eat. And then suddenly, The Guy approaches me, I'm marked. Hey, I know you are you staying at the Jazz Residences? Jazz is about a 12 minute walk to here, and I did not walk towards Makati Ave. from that direction since I just came from the meeting. I'm always guarded with information and paying attention to stuff like that. There's about 20 other places I could…
There's lots of Q&A websites out there talking about Excel bugs that are actually formula errors, and others that talk about recursive VLOOKUPs when they really mean iterative. To be clear on what we are talking about: Excel (2007, 2010, 2011) has an undocumented feature where you can use circular reference in the third argument of VLOOKUP without iterative calculation.
Why should I care?
Here's one type of problem you can solve with this "feature". Suppose we have an organizational chart and want to find how many levels deep each person is. Similar to this problem posted on MrExcel.
IDBOSSNAME1John Smith21Susan Jones32Alice Johnson42Tim Moore51Rachel Parker61Tom Allen75Michael Gross85Kim Dole96Kathy Roberts106Betsy Foster1110Mini Foster
You can do it with this in cell D2: