It worked perfectly with my wine inventory, since I have multiple varitels. Thank you

AMAZINGGGGGG! THANK YOU SO MUCH!

Thank you for the info! My problem is slightly different, I believe. I have a data set with contestant info and their guess to the contest question (a number). I need to find the TWO CLOSEST MATCHING guesses to the correct answer and return the contestant info. Any advise?

Thank you so much!

Thank you so much, very helpful

excellent i like this method. super simple. ty.

Great Work I learned a lot from your videos keep up :)

Very nicely explained on some features. Prefer more coverage of Mobile access and AppSheet development.

It's magic Thanks

Hi, thank you for the in depth video, may I know what to do if I would like to find the last match for a certain reference entry? What should I replace 2 for second match with?

A big thank you

Thanks!! You saved me!!

@ExcelGoogleSheets

2 жыл бұрын

Great!

Very Nice!

THANK YOU SO MUCH

THANK YOU!!

@ExcelGoogleSheets

2 жыл бұрын

:)

i have a list of numbers. how do i search a google sheet for these numbers with one formula. Im trying to cross reference zipcodes that i need with the ones from a list and see how many match

Excellent, any ideas on how to accomplish this with array formula? so that it autoexpands the results as the data grows larger.

@jongoodey4200

3 жыл бұрын

+1 that would be very useful 👍

@ExcelGoogleSheets

3 жыл бұрын

Honestly, I never needed to do that. I don't use array dropdowns as often as people think. If I had to do this I would probably just create a new function with javascript. That would be easier than trying to come up with a way to make this an auto-generating array. The issue here is that spreadsheets don't support 2nd level sub arrayformulas, so you're gonna have to do some crazy workaround to get the results you need if one is even possible. Most of the time that involves creating some sort of sub-table with a VLOOKUP.

Perfect tutorial but what if i want to return first match and second..etc instead of changing the row number?

Hi, is it possible to do this with arrayformula? Thank you!

@Andrew-yw5yw

2 жыл бұрын

@Learn Google Spreadsheets - Is this possible?

I would love something that i can enter Ashton Kent, Finances, and that to get info that finances are his department. I have 1st row and column with cities, and between them is distance. I can figure out how to get the distance between cities from r5 and c10, but I am interested in how to get Column city names. For example, r1 is Denver, i see a lot of distances in colums, and just want to find the biggest, and which city is that. Hope this makes sense, i wrote this after hours trying to figure it out, and couldn't. I tried sumproduct, match, index... nothing

@ExcelGoogleSheets

Жыл бұрын

This? kzread.info/dash/bejne/iZmCu6urZ8WngMo.html

Hi sir! need help here :( i have a table of 2 columns, 1st column is a list of name and 2nd column is some detail. i need a formula in the 3rd column to tell me whether the name on current row has showed up before or not on the list. So the first time a name shows up it will put "first" in it, the next time will leave it blank. Been watching so many videos but i can't find one works as expected. Any help will be much much appreciated!

@ExcelGoogleSheets

2 жыл бұрын

This video should help you kzread.info/dash/bejne/qpN6w9B7lLy7cbw.html

@purplegallery3097

2 жыл бұрын

@@ExcelGoogleSheets thanks a ton sir! i combine this formula with IF function and it solves my problem!! Thanksss

Hello! I'm a big fan of your videos. I want to accomplish something that I think is almost possible with this but I haven't figured it out yet. I have a two lists of people 1. The first list contains Unique Values (names) 2. The second list contains values (names from the first list), but some are duplicated From this I want to return as a list containing all the duplicated values (names) and only if possible the cell reference too (eg. A5, A8). I've been thinking on how to accomplish this for a while with no luck

@ExcelGoogleSheets

3 жыл бұрын

Maybe this? kzread.info/dash/bejne/o65nuaucj7qYfc4.html

@sudoalex

3 жыл бұрын

@@ExcelGoogleSheets Thanks it helped me a lot to figure it out :) I was finally able to approach it

It does not work for me. Could you please help me fix my formula?

Good day, can you make it arrayformula?

Sir if I have n no of matches and I want last match how can I do

Hello! I'm new to Google Sheets. I want to do something similar with this video but the different is that I want to lookup multiple each cell. I mean, in this video you use 1 cell to looking for names and got many results. What about only each cell? So, I don't need to copy the formula to entire columns. Sorry for bad English. English is not my mother language 😅😅

Is it possible to make it return the last match? No matter what number it is. Btw, excellent videos. I have to go on your website to make a donation. You should see the spreadsheet iwas able to create for my business by learning from your channel. I owe you big! Thank you

@jongoodey4200

3 жыл бұрын

I use a technique like this =ArrayFormula(if(len(A:A),row(A:A),)) in one column then in the next column =SORT(A:E,ROW(A:A)*N(A:A""),0) The first formula adds a unique numerical id and then the second reverses the data this way you can get the last matching value as it will always show up first using a vlookup, or using the technique in the video you could get the nth from last as well.

@ExcelGoogleSheets

3 жыл бұрын

Yes, I've recorded a video on this. Should be ready and published within the next couple of weeks.

@goukisan2869

3 жыл бұрын

@@ExcelGoogleSheets thank you guys. i look forward to your next video. @Jon Goodey i will try your formula after work. i appreciate your suggestion !

@yurinakamura9745

3 жыл бұрын

@@jongoodey4200 Hi! can i use this + importrange?

@jongoodey4200

3 жыл бұрын

@@yurinakamura9745 yes I have used this from data coming in from another sheet

Can you link the video that shows how to find ALL matches?

@ExcelGoogleSheets

3 жыл бұрын

All in this playlist kzread.info/head/PLv9Pf9aNgemv99YbzG6u7gxHRTfLRD8vk

how to get this from different google sheet ?

@ExcelGoogleSheets

19 күн бұрын

use IMPORTRANGE function

why the hell do you have to make this so complex?? couldn't you just use one sheet and a small data set for simplicity??