tag:blogger.com,1999:blog-5470394158083527647.post1873476674748471159..comments2024-02-18T03:26:55.922-05:00Comments on Random Diversions: Random Tables II - More ExcelMark Thomashttp://www.blogger.com/profile/13648399258393669436noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5470394158083527647.post-44094105195064021352013-08-13T07:17:04.081-04:002013-08-13T07:17:04.081-04:00VLOOKUP is using values from column A. It searches...VLOOKUP is using values from column A. It searches beginning in A2, and hits 76, which is larger than the searched-for 64. In that situation it returns the previous row. The 77 is a typo in the text (fixed).Mark Thomashttps://www.blogger.com/profile/13648399258393669436noreply@blogger.comtag:blogger.com,1999:blog-5470394158083527647.post-22941049426847455832013-08-12T19:58:32.913-04:002013-08-12T19:58:32.913-04:00Very slick. One question:
1. In your example did t...Very slick. One question:<br />1. In your example did the VLOOKUP find 77 or 76? <br />Nether Krakenhttps://www.blogger.com/profile/16563450444432612828noreply@blogger.com