Excel Lookup Series #12: INDEX & MATCH functions Example 2!

[chelseafcman2]

I've been looking for these formula's for ages, cheers mate.

[TheDeathsuponus]

thanks again

[ExcelIsFun]

@TheDeathsuponus , you are welcome again!!

[LiuWanfei]

you r the best and these are amazing videos! Thank you so much!!

[ExcelIsFun]

@LiuWanfei , You are welcome!

[ondogagita]

ur the best tutor!

[ExcelIsFun]

I am glad that the video helped!

[ondogagita]

ur the best tutor!

[ExcelIsFun]

@ondogagita , Thanks! I am glad that you like the video!

[tohrebecca]

This is my saviour.. =)

[ExcelIsFun]

I am glad that it helps!

[dizzydave04]

You're my HERO!!!



[ExcelIsFun]

I am glad that the videos help!

[rafiesh1]

You R the best

[ExcelIsFun]

Just a guy having fun with Excel!

[ayhan129]

@ExcelIsFun hi is t possible to use match and index instead of vlookup all the times best wishes

[ExcelIsFun]

Yes. INDEX and MATCH can do everything that VLOOKUP can do and MUCH more. INDEX and MATCH are much more versatile. However, more people know how to use VLOOKUP than INDEX and MATCH, so in some circumstances it may be better to tailor a formula that uses VLOOKUP. Here are some references videos:

Highline Excel Class 40: VLOOKUP 11 Unusual Examples

Highline Excel Class 44: Basics of INDEX & MATCH functions

Highline Excel Class 45: INDEX function & MATCH function 12 Unusual Examples

[sartaj2304]

Hi, i enjoy watching your vidoes and our a great help. You make it easy. I needed to know do you have a video on using look up with mutliple criteria. I am aware of using index and match funbction. But what if there are multiple outputs.

eg. the output function has Weekly tasks for Ajay for the period of jan. There maybe 10 tasks for ajay. Please advise.

[ExcelIsFun]

Try these videos:

2 criteria:

Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup values

mutiple outputs:

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value ...

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value ...

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value ...

[Shtypes]

I'm having troubles to find and download the workbook for this lesson. May you help me by providing the link. Thanks and congratulation for your excellent job here.

[ExcelIsFun]

YouTube does not allow links in the comment section.

Search for and watch this video title:

Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun

This shows how to download.

[jigmandude]

thx so much man i looked at 2 of ur vids, both of em helped me with 2 of my problems in my spreadsheet. its kinda hard to find help for my exact problem, but u hit it on the head twice. you are 2 for 2 right now, keep it up

[ExcelIsFun]

I am glad that the video helped.

Be sure to search YouTube for "excelsisfun", then go to the excelisfun channel, then watch the how to find videos I have posted - it will help you find exactly what you want.

[dhawanmk]

kindly let us know whre is the link to download this series

mkdhawan

[ExcelIsFun]

YouTube does not allow links in the comment section.

Search for and watch this video title:

Search & Find Excel Videos, Playlists, Download Workbooks - excelisfun

This shows how to download.

[pjtopj24]

Thanks!!!

[ExcelIsFun]

Dear pjtopj24,

You are welcome!

--excelisfun

[carlm189]

thank you very much it works perfectly - i appreciate your help

carl

[carlm189]

the lookup value in this case would be B24,

basically i have this in a cell:

[AB 02 ABC]

i need to ignore the first AB to read the 02

once i have done this i will be able to lookup a value from an array in another worksheet

[ExcelIsFun]

Dear carlm189,

A formula like this would work if the AB 02 ABC was in cell A1, the number was always 2 characters longm, and the lookup table was on a sheet called Data:

=VLOOKUP(LEFT(REPLACE(A1,1,FIN­D(" ",A1),""),2),Data!$C$11:$D$13,­2,0)

--excelsifun

[carlm189]

could you tell me how you would look up the "02" value in the cell b24 please, im really stuck and need to know how to look up a value within the cell

[ExcelIsFun]

Dear carlm189,

If you want to return the "02" value from the cell B24, what is the lookup_value (the first argument in VLOOKUP)? Please explain your setup more clearly and I will try to help.

--excelisfun