Forum Discussion
Vlookup problems
I am trying to use Vlookup to create some calculations for some data, but the lookup value, is not always used, so I get the #N/A error. I use a lookup which searches three separate sheets for a sp...
My solution.
=MAX(0,SUM(XLOOKUP(B2,'22GP Raw data'!$A$2:$A$5,'22GP Raw data'!$D$2:$E$5,0)*{1,-1}))
Doesn't work, as formal is for too smaller data range. Tried amending to include the data range, receiving errors. In the message posted I was using row numbers for the Vlookup, as I am trying to create a formula that can be used for several purposes.
If you would use formatted Excel tables and structured reference in the formulas then there won't be a problem with a too small data range. The ranges will expand automatically.
