Generate Random Text in Excel using Hlookup

[@OzduSoleilDATA]

Very nice tip. I never thought of using HLOOKUP for that.

[@Excelrush]

Thank you Excel On Fire! Do subscribe to the channel for more such tips!

[@Legion_Ap3X]

Cool but how to not get duplicates?

[@yogeshglimbarkar5307]

I tried this formula but I got 0 values in each cells

[@Excelrush]

Hi Yogesh, can you copy paste your formula here? Let me check it.