Multiple results in Lookup with multiple condition

In this video, I have explained about lookup function which can be used for multiple conditions and how can we get multiple results using small function. If you want to understand more about small function how actually it can be used, you should definitely check below playlist on google sheets.




The logic behind overall function is we are using reference features in google sheets and array formula to perform multiple iterations and by using if function with it, can give us desired output.


If you want to learn google sheets then do follow below playlist:


See magic of google apps script here:


Do watch, share and subscribe to channel and do let me know your valuable feedback in comment section.

master in spreadsheet,google sheets,spreadsheet,anand padhiyar,google sheet kese sikhe,google sheets tutorial,spreadsheet tutorial,sheet tutorial,anand channel,anand,google sheets basics,google sheets vs excel,multiple lookup condition,multiple lookup results,how to get multiple results using lookup function,how to check for multiple condition in lookup function,advance lookup function,index-small function,if condition in lookup function,