=LOOKUP not working correctly
![jb@59069](https://us.v-cdn.net/6031209/uploads/userpics/286/nW75MI641ONQO.jpg)
Hello,
I have multiple sheets that need to use this exact =LOOKUP function, but I cannot get it to work correctly.
See LOOKUP Table.jpg for the data, TC1 = left column, TC2 = right column, rows 17-22
See LOOKUP Problem.jpg for what gets displayed: TC Class = Left column, TC Class $ = right column
The formula in TC Class $: =LOOKUP([TC Class]@row, $[TC1]$17:$[TC2]$22, 2)
Why do "#NO MATCH" and incorrect values show up?
Answers
-
Hi @jb@59069
There's an optional setting at the end of a VLOOKUP function to specify if you're looking for an exact match or approximate match. I notice you haven't specified this in your formula, so it will default to approximate. Try adding "false" to the end of your formula to ask it to find an exact match, like so:
=VLOOKUP([TC Class]@row, $[TC1]$17:$[TC2]$22, 2, false)
See here for more information: VLOOKUP Function
If this hasn't resolved the issue, I'd be interested to see if an INDEX(MATCH formula would find the match, instead.
Try this:
=INDEX($[TC2]$17:$[TC2]$22, MATCH([TC Class]@row, $[TC1]$17:$[TC1]$22, 0))
Let me know if either of these have worked for you!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Hi @jb@59069
Thanks for pointing that out! I see that it's referenced in the syntax but not in the formula example, I'll pass your feedback along.
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!