Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
how it works
applymap('item',product,'100%')
what is 100% here i know that not matching values will go there is in't or anything is there?
Hi,
Yes right when no value match 100% is fill there.
Regards
Anand
This 3rd parameter can be anything whatever you want to insert dummy value if condition is not matching
It works just like VLOOKUP in Excel but the lookup table must only contain 2 columns
see this also