3

I am trying to use vlookup to find the sales rep with the highest revenue within my data set. I am getting an error message saying the value being found is not a number (which is the sales rep's name). Not sure how to fix this issue.

I have read Index/Match formulas that may work but I am not sure how to use them.

=VLOOKUP(L6,DATA!E:E,DATA!C:C,false)

#VALUE! Function VLOOKUP parameter 3 expects number values. But 'JESSE CAMIRE' is a text and cannot be coerced to a number.

player0
  • 124,011
  • 12
  • 67
  • 124
Austin Farmer
  • 125
  • 1
  • 1
  • 8

1 Answers1

1

try like this:

=VLOOKUP(L6, {DATA!E:E, DATA!C:C}, 2, 0)

if L6 is found in DATA!E:E vlookup will return value from 2nd column eg. DATA!C:C but only if an exact match is found hence 0

player0
  • 124,011
  • 12
  • 67
  • 124