Hello,
Could someone look at my attached example and explain why none of my xlookup formulas are calculating? I have color-coded the xlookup's lookup_value as it corresponds to the formula.
Each color is a different way to code the formula but it should return the same result.
Thanks
The result of A1&B1 is a text string (1&3="13"). The values in column D are all numbers. The text string "13" is not the same as the number 13, so Excel's lookup functions do not recognize the match. Try something to force the result of A1&B1 to be a number. Maybe =A1*10+B1, or VALUE(A1&B1) or A1&B1+0 or something similar.
Originally Posted by shg
Ah, MrShorty. You have led me in the right direction. I chose to go in this direction instead which solved the error I was getting:
In A2 I did an =--CONCATENATE(""&A1&""&B1&"") this comes to a plaintext string of "13"
then proceed to use =XLOOKUP(A2,D1:D15,E1:E15) in E17 which returned the proper result.
I appreciate your help. I had never run into this situation before.
@ sussington
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Thank you ahead of time.
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks