Forum Discussion

PeterK007's avatar
PeterK007
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's avatar
    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)

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Mar 13, 2022

PeterK007 

column1column2column3column4
16.08.202176south60
27.09.202144south90
10.10.202156north10
12.10.202182north100
15.10.202161east80
27.10.202152south30
30.10.202141east50
06.11.202113east110
23.11.20213north70
26.11.202113north40
06.12.202133east20
    
01.11.2021 search value cell A14 
    
50 =VLOOKUP(A14,A2:D12,4,TRUE) 

 

Maybe you can paste your data into your post as shown in the above example.

  • PeterK007's avatar
    PeterK007
    Copper Contributor
    Mar 14, 2022
    Thank you for the hint. I was afraid that it may not work since the sheet does not throw any errors and the formula is formed correctly. Nevertheless, I found a workaround, which is to upload the file to OneDrive and then share it with the following link: https://1drv.ms/x/s!AhoU6FwcGDdkgke1Rqgj7No-V0l-?e=TQA77X

Resources