logo elektroda
logo elektroda
X
logo elektroda
Advanced Search
logo elektroda

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

adamza 10497 4
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
Report a violation of the law
| New topic
  • #1 12415834
    adamza
    Level 12  
    Posts: 106
    Help: 2
    Rate: 8
    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 (89.5 KB) You must be logged in to download this attachment.
  • ADVERTISEMENT
  • #2 12415864
    cbrman
    Level 27  
    Posts: 441
    Help: 177
    Rate: 61
    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
    adamza
    Level 12  
    Posts: 106
    Help: 2
    Rate: 8
    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
    adamas_nt
    VIP Meritorious for electroda.pl  
    Posts: 5320
    Help: 1508
    Rate: 659
    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
    adamza
    Level 12  
    Posts: 106
    Help: 2
    Rate: 8
    Thanks a lot. :)
| New topic
Report a violation of the law
ADVERTISEMENT