andrew58695
New Member
- Joined
- May 17, 2017
- Messages
- 3
Hello,
I am trying to use lookup a value and check if it exist in a large dataset (~1 million lines). Obviously, I can use vlookup, but even if I lookup the value in another excel file it tends to slow things down quite a bit and I anticipate the file will grow to be quite large. I've been taking some online classes on Excel and was hoping to use power query to accomplish this much easier (assuming my very basic understanding of it is correct).
Basically I have a table in Excel with a column that needs to check if value "123456" (also in the excel table) exists in the much larger dataset, and have it return yes/no. This table will continue to grow, as will the larger dataset. Easy stuff? My experience here is not very in depth but I am hoping to learn more.
Help/pointers appreciated.
I am trying to use lookup a value and check if it exist in a large dataset (~1 million lines). Obviously, I can use vlookup, but even if I lookup the value in another excel file it tends to slow things down quite a bit and I anticipate the file will grow to be quite large. I've been taking some online classes on Excel and was hoping to use power query to accomplish this much easier (assuming my very basic understanding of it is correct).
Basically I have a table in Excel with a column that needs to check if value "123456" (also in the excel table) exists in the much larger dataset, and have it return yes/no. This table will continue to grow, as will the larger dataset. Easy stuff? My experience here is not very in depth but I am hoping to learn more.
Help/pointers appreciated.