Thread: Vlookup fails to select latest date/amt
View Single Post
 
Old 01-26-2019, 11:03 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
1. When you enter the formula into cell D4 with parameters as in your post, then both VLOOKUP() and MAX() parts have circular reference;
2. What is the value for parameter T in VLOOKUP()? And why not simply 0?
Reply With Quote