Forum Discussion
Douglas997t
Jun 08, 2022Brass Contributor
VLOOKUP returns a blank cell when all references are accurate?
I am having trouble with VLOOKUP. I have created the following =VLOOKUP(C6,L8:II51,3) whereby the value in C6 is the biproduct of A6 and B6 through =CONCATENATE(A6,B6). The range and the column numbe...
- Jun 08, 2022
Change the formula to =VLOOKUP(C6,L8:II51,3,FALSE)
HansVogelaar
Jun 08, 2022MVP
Change the formula to =VLOOKUP(C6,L8:II51,3,FALSE)
- Douglas997tJun 08, 2022Brass ContributorPerfect. Thanks Hans!