MS Excel | Nested XLookup

preview_player
Показать описание
This video covers the XLookup function and how to use it to search for values in a 2 dimensional table in the spreadsheet software Microsoft Excel. This is done using a nested Xlookup.

#MrLongEducation #Excel #XLookup
  1. Mr Long Education - IT & CAT
  2. Mister Long
  3. Mr Long
  4. Mister Long Education
  5. CAT
  6. Computer Application Technology
Рекомендации по теме
MS Excel | 0:07:20

MS Excel | Nested XLookup

Excel Two-Way XLOOKUP 0:04:04

Excel Two-Way XLOOKUP - How to use XLOOKUP with two criteria in Excel | Nested XLOOKUP Tutorial

How to Use 0:13:34

How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)

How to Use 0:04:22

How to Use XLOOKUP Function For 2 Different Lists In Excel (Nested XLOOKUP)

XLOOKUP with Multiple 0:03:24

XLOOKUP with Multiple Conditions

XLOOKUP and Nested 0:10:28

XLOOKUP and Nested XLOOKUP (With 5 Practical Examples)

Nested XLOOKUP Function 0:03:58

Nested XLOOKUP Function in Excel

Excel Tips - 0:06:09

Excel Tips - XLOOKUP and Nested XLOOKUP Explained

Nested XLOOKUP formula 0:07:05

Nested XLOOKUP formula in excel | Dynamic sum trick

XLOOKUP in Excel 0:16:40

XLOOKUP in Excel Tutorial

The Ultimate XLOOKUP 0:11:03

The Ultimate XLOOKUP Tutorial (The Best Excel Formula)

Nested XLOOKUP 0:03:48

Nested XLOOKUP

Nested XLOOKUP with 0:07:43

Nested XLOOKUP with SUM function in Excel

How to use 0:03:10

How to use Nested Xlookup to build two-way lookup in Microsoft Excel | Learn in 5 Minutes

Excel Tips - 0:00:52

Excel Tips - Nested XLOOKUP

Nested Xlookup : 0:04:30

Nested Xlookup : Excel Tricks

Excel 2-way Lookup 0:00:59

Excel 2-way Lookup with nested XLOOKUP #shorts

XLOOKUP with Multi 0:06:56

XLOOKUP with Multi Criteria Lookup | How to use XLOOKUP multi criteria? [Never seen this before!!!]

Nested XLOOKUP with 0:03:08

Nested XLOOKUP with MIN Function

How to use 0:01:00

How to use a nested XLOOKUP within an XLOOKUP

Excel IF Formula: 0:15:23

Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)

Excel XLOOKUP Function 0:04:14

Excel XLOOKUP Function with Three Lookup Values?–- Excel Magic Trick 1601

XLOOKUP Function 10 0:07:10

XLOOKUP Function 10 Nested Xlookup

Xlookup 5 New 0:13:32

Xlookup 5 New and Improved Examples with Double or Nested Xlookup

Комментарии
Автор

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?

GpD
Автор

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?

ublogs