Forum Discussion
dmgaddy8247
Feb 01, 2019Copper Contributor
VLOOKUP anamoly?
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,...
Detlef_Lewin
Feb 02, 2019Silver Contributor
*
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?