1

When I use VLookup to auto fill rows from a chart, it works for every search value except searches where the lookup value is CPT-X. In this scenario original formula:

If I change the lookup value to "wow" or "sad" it finds the correct value and outputs correctly. Which makes zero sense to me. See images attached.

"wow" input

Scott Craner
  • 22,693
  • 3
  • 21
  • 25
Spencer
  • 11
  • 1
  • 2
    use the forth criterion when trying to find exact match: `=VLOOKUP(B13,$H$2:$O$12,6,FALSE)` Otherwise the lookup range must be sorted ascending. – Scott Craner May 06 '22 at 14:35
  • 1
    See this answer for an explanation of how VLOOKUP works when the forth criterion is TRUE, which is the default: https://superuser.com/questions/1719222/vlookup-logic-when-range-lookup-is-true-but-table-array-is-not-sorted – Scott Craner May 06 '22 at 14:36

1 Answers1

0

Change the formula to:

=VLOOKUP(B13,$H$2:$O$12,6,FALSE)
Lee
  • 2,923
  • 1
  • 6
  • 8