Hi, I have an excel file, I would do vlookup for 3 columns(nonconsecutive). However, if the value is ‘#N/A’, I need to do another vlookup. Thus, i need to convert the formula to value.
It looks like this
After converting from formula to value, it will look like this
I am aware of there is a ‘send hotkey’ activity. And below is the hotkey
However, my question is how to select that particular column cells?
Here is the excel file for referral:
Sample - NFS Exception Report.xlsx (11.5 KB)
Thank you xoxo