Hello, Can someone explain to me what is wrong with this VLOOKUP ?? I tried to convert the text to a number but it crashes me some nonsense, i.e. the values do not match. Please explain what I am doing wrong so that I know for the future :) Moreover, the function does not display the searched...

and that's it ... More precisely: it searches the leftmost one. Swap the columns and it will work ...

Actually, it works fine because VLOOKUP looks up the values in the column on law from the searched column, in your case you need to use INDEX from MATCH / MATCH Code: text Expand Select all Copy to clipboard=INDEKS($A$1:$B$875;PODAJ.POZYCJĘ(F2;$B$1:$B$875;0);1)

Why not VLOOKUP ???? please clarify the topic, I like to use VLOOKUP and I do not understand why it does not work because it should compare the tables and give the result

Excel VLOOKUP Issue: Fixing #N/A Error, Converting Text to Numbers & Displaying Searched Values

adamza 10053 4

Treść została przetłumaczona

Zobacz oryginalną wersję tematu

| New topic

#1 12415834 14 Jun 2013 11:25

adamza adamza

Level 12
» |

Post #1
12415834 14 Jun 2013 11:25

Hello,

Can someone explain to me what is wrong with this VLOOKUP ??
I tried to convert the text to a number but it crashes me some nonsense, i.e. the values do not match. Please explain what I am doing wrong so that I know for the future Moreover, the function does not display the searched value
Thanks

Attachments:

vlookup.xls Download (89.5 KB)
ADVERTISEMENT
#2 12415864 14 Jun 2013 11:37

cbrman cbrman

Level 27
» | Helpful post? (0)

Post #2
12415864 14 Jun 2013 11:37

Actually, it works fine because VLOOKUP looks up the values in the column on law from the searched column, in your case you need to use INDEX from MATCH / MATCH

Code: text Expand Select all Copy to clipboard
=INDEKS($A$1:$B$875;PODAJ.POZYCJĘ(F2;$B$1:$B$875;0);1)
ADVERTISEMENT
#3 12415908 14 Jun 2013 11:56

adamza adamza

Level 12

» | Topic author Helpful post? (0)

Post #3
12415908 14 Jun 2013 11:56

Why not VLOOKUP ????
please clarify the topic, I like to use VLOOKUP and I do not understand why it does not work because it should compare the tables and give the result
ADVERTISEMENT
Helpful post

#4 12415957 14 Jun 2013 12:17

adamas_nt adamas_nt

Moderator of Programming

» | Helpful post? (+1)

Helpful post
Post #4
12415957 14 Jun 2013 12:17

cbrman wrote:
because VLOOKUP looks up the values in the column to the right
and that's it ... More precisely: it searches the leftmost one.
Swap the columns and it will work ...
#5 12415971 14 Jun 2013 12:22

adamza adamza

Level 12

» | Topic author Helpful post? (0)

Post #5
12415971 14 Jun 2013 12:22

Thanks a lot.
Create an account, log in and become active in a forum and ads will not appear. You will receive points by participating in discussions.
Join this discussion.

Install the application

Didn't find an answer? Ask Artificial Intelligence

*I agree to send the question to OpenAI, Anthropic PBC, Perplexity AI, Inc., Kagi Inc., Google LLC - owners of language models in order to prepare the best response. The companies may monitor and log information entered into the form.

*I agree to publicly display my question and answer. The question and answer will be publicly available to everyone. The process may take a few minutes. Upon completion, you will be redirected to the page with the answer.

Wait...(2min)

| New topic

Report a violation of the law

Excel VLOOKUP Issue: Fixing #N/A Error, Converting Text to Numbers & Displaying Searched Values

Didn't find an answer? Ask Artificial Intelligence