This is really awesome. Thank you for putting this together. Is it possible to nest "If" functions in an xlookup? For example, I have a spreadsheet with a bunch of names on there and may see the same Timmy Jones on the spreadsheet 6 times, but I only want the info that has a date between a certain range of dates. For example, only the February date. Could xlookup look for Timmy Jones and spit back info for the entry for February? Does that sound like something xlookup could do?
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?
Fantastic
This is really awesome. Thank you for putting this together. Is it possible to nest "If" functions in an xlookup? For example, I have a spreadsheet with a bunch of names on there and may see the same Timmy Jones on the spreadsheet 6 times, but I only want the info that has a date between a certain range of dates. For example, only the February date. Could xlookup look for Timmy Jones and spit back info for the entry for February? Does that sound like something xlookup could do?
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?
Nice.
thank youu😊