Feb 01 2019 12:53 PM
How can a VLOOKUP work fine in one column (C) of my worksheet but returns a #REF! error in another(F)? Using data from another sheet in the workbook, I compile a monthly report for billing. However, recently the formula is failing. The original spreadsheet was done in Excel 2010, but is now in Excel 2016.
Sheet name: webdata
A B C
Domain DBsize Bandwidth
website.com, 1.01 1.11
another.com 0.94 0.15
athirdsite.com 2.25 2.02
Sheet name: report
Row: Domain, type, DBsize, FilesMB, Total, Bandwidth
In cell C6: =VLOOKUP(A6,webdata!$A$2:$B$122,2,)
In cell F6: =VLOOKUP(A6,webdata!$A$2:$B$122,3,)
A B C D E F
5 Domain name Type MySQL(MB) Files(MB) Total Bandwidth(MB)
6 website.com S 1.01 973.9 975 #REF!
7 another.com #REF!
8 athirdsite.com #REF!
Help?
DG
Feb 01 2019 01:22 PM
Feb 01 2019 01:36 PM
Regardless if the trailing 0 is there or not, it still returns the same error:
"The cell currently being evaluated contains a constant."
#heavysigh
DG
Feb 01 2019 02:20 PM
Feb 02 2019 01:31 AM
*
@dmgaddy8247 wrote:In cell F6: =VLOOKUP(A6,webdata!$A$2:$B$122,3,)
Your matrix is two columns wide. So how do you expect a return value from column 3?