Forum Discussion

Copper Contributor

Mar 13, 2022

Solved

Vlookup function returning 0 instead of the cell value.

Dear community. It is my first post so be patient with me 😜 I have a problem with VLOOKUP function. When I am typing in: =VLOOKUP(B2,hourly_stock_pl,3,TRUE) the function returns the correct values...

excel

Formulas and Functions

HansVogelaar
Mar 14, 2022
PeterK007

None of the part numbers in column B of the Destination sheet match any of the values in the first column of hourly_stock_pl.

Use

=VLOOKUP(B2,hourly_stock_pl[[p_pn]:[imStock]],2,FALSE)

and

=VLOOKUP(B2,hourly_stock_pl[[p_pn]:[imStock]],3,FALSE)

NikolinoDE

Platinum Contributor

Mar 13, 2022

PeterK007

Drag and drop here or browse files to attach

Maximum size: 71 MB • Maximum attachments allowed: 5

PeterK007
Copper Contributor
Mar 14, 2022
NikolinoDE
Thank you for the reply. Sadly, I do not see the browse function. When trying to drag and drop it does not upload. However, I found a workaround, which is to upload file to onedrive and then share it here with the link: https://1drv.ms/x/s!AhoU6FwcGDdkgke1Rqgj7No-V0l-?e=TQA77X
- HansVogelaar
  MVP
  Mar 14, 2022
  PeterK007
  
  None of the part numbers in column B of the Destination sheet match any of the values in the first column of hourly_stock_pl.
  
  Use
  
  =VLOOKUP(B2,hourly_stock_pl[[p_pn]:[imStock]],2,FALSE)
  
  and
  
  =VLOOKUP(B2,hourly_stock_pl[[p_pn]:[imStock]],3,FALSE)
  - PeterK007
    Copper Contributor
    Mar 14, 2022
    Hi, Thank you very much. It does solve my problem and it works 🙂 providing correct values.
    I would be even more grateful if you could explain to me why the previous formula did not work and why adding |[[p_pn]] to the formula works. What does it do?