Forum Discussion
Excel using vlookup not calculating after 3 steps in spreadsheet---#NAs start "pop up"
It is a workbook I created years ago. Have edited it adding different functions. I check formulas back to 2005 and all continue to work. But stops working in 2013- 2014. Earlier copies are in "Compat...
Hi,
Would you be able to indicated which sheet and cells you are having trouble with the VLOOKUP? The spreadsheet you attached is very large making it difficult to pinpoint the issue.
Thanks
The computations page. Cell B7----=IF('Input Form'!B5>=0,VLOOKUP(B3,'Rates 2019'!$A$3:$G$37,VLOOKUP(B4,'Rates 2019'!$J$3:$K$7,2,FALSE)+1,FALSE),"0")
This formula has worked since 2005. Since I started using Office 365 - Excel 2016, it has not worked.
