VLOOKUP, HLOOKUP
I did'nt understood the application of vlookup and hlookup at all, watched the video many times still stuck, I always ask myself why I'm doing this what is actual use of this.
Can anyone me provinding any youtube link or any other refernce so I can understand.
Have been stuck for weeks regarding this topic
1 answers ( 0 marked as helpful)
Hi Ansh,
Good to hear from you!
The application is that when you have data in one place, you will be able to look it up and use it many times over.
Say you have a list with 10,000 rows of customer profiles.
You want to obtain every customer's ZIP code, but you only know their city of living. You can create a 20 row table with ZIP codes per city and then use this information to fill in the large 10,000 rows table.
Best,
Ned
Good to hear from you!
The application is that when you have data in one place, you will be able to look it up and use it many times over.
Say you have a list with 10,000 rows of customer profiles.
You want to obtain every customer's ZIP code, but you only know their city of living. You can create a 20 row table with ZIP codes per city and then use this information to fill in the large 10,000 rows table.
Best,
Ned