Waste of time. This is yet another (I stopped counting at about 300) example of bad data structuring and a solution looking for a problem that should not exist in the first place. If you want to use Excel as a database I suggest you first learn how databases and normalization work...
@mojonespro3 ай бұрын
Please clarify and or provide an efficient solution. The very nature of data is to be queried.
@hernandez55863 ай бұрын
Most company don’t use databases as they should and strictly use spreadsheets. You’re either a kid or an adult that’s never had a job in data.
@hernandez55863 ай бұрын
@@mojonesprokeep up the good work
@phandongexcel3 ай бұрын
I like this video ❤❤❤
@viveksahu68243 ай бұрын
Nice video....I was using an older version of Excel and did the same thing using vlookup function.
@mojonespro3 ай бұрын
Nice work!
@user-fy4yd9tz4w4 ай бұрын
I’m curious as to why you went through the trouble of going to the FORMULA RIBBON, clicking on the INSERT FORMULA icon then typing in the XLOOKUP FORMULA when you could have just put the cursor into the cell where you want the formula and type =XLOO… which brings up your function choices with XLOOKUP coming up as the first choice. Then hit the tab key and your formula appears. This is not a put down but rather a sincere inquiry. Thanks
@mojonespro4 ай бұрын
Good question. As an educator, I find it useful to utilize the function arguments dialog when teaching functions with multiple arguments. I don't want to assume that all of my students are accustomed to writing out the function in a cell. The function argument box provides more detail and guidance.
@meniporat35274 ай бұрын
Here's a trick to fetch all the values (even from non-adjacent columns) in one XLOOKUP statement. No need to bring the Date column in a separate statement: =XLOOKUP(H6,A6:A23,CHOOSECOLS(B6:F23,{1,2,3,5})) This formula will return data from the following columns: Name, Level, Price, Date