2 Way Lookup, INDEX MATCH, VLOOKUP - Excel & Google Sheets

2 Way Lookup, INDEX MATCH, VLOOKUP - Excel Google Sheets.

#indexmatch #excel #googlesheets

[OmriLevy]

Keep up the great work!
Probably the best Google Sheets teacher on the internet.
Thx!

[General_Cap]

Thank you for this video - I had been trying for about 3 hours figuring out how to do a matrix value assignment based on an x cordinate and y cordinate and this video solved that setup for me.

[TaraAmerica]

I am crying happy tears. Thank you so much for solving my matrix formula woes!

[lpanebr]

It's good to learn about the Xmatch! Thanks for the great content!

[mercyfrs]

He 's true master!..Great teacher.

[syukraakhmad]

Your video make me famous in my Job😂, thanks 🙏

[ds-]

How would you find the regions instead if there is number under that region (or a check mark), like Jake has 2 region that has numbers, I want the result to show Jake | Midwest | Northeast

[alizaenalabidinassegaf]

wich one is better speed to find at large data? vlookup or indexXmatch? coz i need to combine with an arrayformula

[Mohammedbasim]

What is your opinion about using DGET function instead of the above two to solve the above problem.

[GM]

Would Xlookup be useful for this problem? I was able to use Xlookup by using Filter for the results range when I used a finite lookup range. I could not get it work, though, if I tried to use an entire row or entire column for the lookup ranges, because then the ranges would be of different sizes.

[syukraakhmad]

I have 200 Sheets about employee performance, how to make it just 1 sheet? Please help me.

[latest]

Make video on all finance function pl.

[ignacioa]

why is my XLOOKup not correctly searching for normal accoutn numbers like: 345677 ? When that same number is in the column that my XLOOKUP is looking at, but my XLOOKUP is saying that is "Not found" based on my criteria, but again it should come back as a match but XLOOKUP is not matching it?

[Shotglass]

Hi - I’m having trouble linking a specific cell (or range of cells) from one workbook to another. Creating the link from the source workbook and inserting it onto the second workbook isn’t the problem. The problem is, after updating information on the source workbook and adding rows, the linked cell is no longer correct.

Specifically, I have a directory of school districts listed in a Google Sheets workbook. And I have a separate workbook of construction projects happening in those individual school districts.

I’ve created a link to those specific School Districts on the Projects workbook, so that each Project references a corresponding School District the work is being performed in. And likewise, each School District lists the Projects.

However, after updating the School District workbook with each individual Project by adding a row, all the linked School Districts referenced in the Projects workbook are wrong because the destination has changed.

I’ve watched dozens of YouTube videos and your collection has helped me with numerous issues and challenges. In particular, conditional formatting with a formula you showed me how to create. But with this problem I’m not quite sure where to begin.

Please help. Thanks in advance. -Chris @ExcelGoogleSheets