Generate Random Text in Excel using Hlookup

preview_player
Показать описание
It is quite easy to generate random numbers and dates, but more complicated when it comes to text.
You might have used =CHOOSE to generate random text, but using =HLOOKUP is much easier to use in this case.

SUBSCRIBE NOW!

Click this link to learn more awesome functions in Excel

Click this link to learn how to manage your personal finance using Excel
Рекомендации по теме
Комментарии
Автор

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

OzduSoleilDATA
Автор

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

yogeshglimbarkar