Forum Discussion

Douglas997t's avatar
Douglas997t
Brass Contributor
Jun 08, 2022

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...
  • HansVogelaar's avatar
    Jun 08, 2022

    Douglas997t 

    Change the formula to =VLOOKUP(C6,L8:II51,3,FALSE)

Resources