I'm having trouble getting vlookup to return the correct value.
The lookup_value is BBB*-
The table array is below:
BBB+*- 8
BBB+e 8
BBB+ 8
BBB+*+ 8
BBB 9
BBB*+ 9
BBBe 9
BBB*- 9
But the vlookup is returning 8 instead of 9. Is there anything I can do to fix this? I attached an excel sheet with the issue. Thanks for the help!
Hi,
Sort the A1:B8 list first using column A as the sort key.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
This should do the trick.
Confirm with CTRL Shift Enter
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks