Thanks! I literally woke up this morning with the idea of using xlookup with sumif and this is exactly what I needed!

@Computergaga

2 жыл бұрын

Awesome! 👍

Hi Alan.. great examples of using XLOOKUP to return a range of values for further processing. Thanks for the insights. Thumbs up!

@Computergaga

4 жыл бұрын

My pleasure Wayne.

Thanks Alan for the good examples. 👍 These dynamic arrays and Xlookup are changing everything in Excel..

@Computergaga

4 жыл бұрын

They certainly are Salim.

I've been looking for this for ages, thank you so much, works perfectly on tables too. Well explained too. Many thanks.

@Computergaga

Жыл бұрын

You're welcome! Thank you, Adam.

Very helpful. Including your statement that this could be used with sumifs. Thank you for taking the time to do this.

@Computergaga

3 жыл бұрын

Glad it was helpful! Thanks Gary.

Thanks for the great video! It almost got me across the finish line. I need the formula. to sum multiple matches in columns and rows. So close, yet so far... any advice welcome. Cheers

This is great! For some reason the official reference page of XLOOKUP made me think it did not return ranges. Thank you for the video!

@Computergaga

Жыл бұрын

You're very welcome. Thank you.

Thanks sir very informative video I will share it with my friends and colleagues.

@Computergaga

4 жыл бұрын

Thank you very much Babar.

Hi Alan, If this workbook can be downloaded, that will be great. Thanks.

Thank you for your video..🤗❤ it's awesome..XLookup😎

@Computergaga

4 жыл бұрын

Thank you Raza.

@razamoulvi8801

4 жыл бұрын

@@Computergaga you most welcome🤗

I am getting a #VALUE error and a zero when I try re-arranging my formula range, and I set it up the same way Alan did. Where can I find out what I'm doing wrong since I'm kind of stuck?

SIR, EXCELLENT & VERY INFORMATIVE. WOULD BE NICE IF YOU PROVIDE LINK TO DOWNLOAD THE SPREADSHEET TO FOLLOW ALONG. THANKS.

@Computergaga

3 жыл бұрын

Thank you, Rajeev. Yes, I don't believe I have the file for this around anymore. But I'll have a look.

Thanks for sharing your expertise. Can you tell me please how you would write a formula to allow for expansion of your data set? So for example, if you were to update the list of food items with additional rows?

@fraggle200

Жыл бұрын

make it a table. then it'll just ref the table column instead of a cell range.

@Computergaga

Жыл бұрын

You're welcome. The other comment has answered your question. Click inside the range and press Ctrl + T to convert it to a Table.

I do not understand why I only have the last match, not the sum, somebody knows why?

i have a question. there are two tables (created with ctrl + t command) on the same sheet in first table there are two headings 1. subject 2. marking type (means particular subject will be awarded grades or marks) (for example there are four subjects i.e. ENGLISH , MATH, DRAWING, SPORTS, MUSIC) [FIRST TWO SUBJECTS WILL BE AWARDED MARKS AND REST OF THREE WILL BE GRADED] now there is second table having one column 1. grading subject aim of creating second table is to show only grading subjects from ist table WHICH ARE DRAWING SPORTS AND MUSIC XLOOKUP NOT WORKING IS THERE ANY OTHER OPTION?