Forum Discussion

DauletKali's avatar
DauletKali
Icon for Helper I rankHelper I
5 years ago

Double VLOOKUP

Hi guys, need your help in solving my problem

I need that function(s) which will return the number(3) if the Date(1) will be equal to TODAY() and the item (2) ="Селитра аммиачная

 

 

1 Reply

  • arvindsingh802's avatar
    arvindsingh802
    Icon for Community Champion rankCommunity Champion

    This can be achived with If condition rather than lookup..

    If you wanna lookup based on two columns just concate column1&2 and then do lookup