Forum Discussion

Shital25's avatar
Shital25
Copper Contributor
Jun 01, 2022

How to use vlook for blank and non blank cells

Hi,    I have a set of data set 1 and set 2 where I want to use vlookup from set 1 and search the amount 1 but if set 1 is blank need to show amount1 only , again in next match it has to show ...

Resources