Excel Lookup With Multiple Criteria

Excel Lookup With Multiple Criteria

Contextures Inc.

8 лет назад

94,602 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

iamalemontree
iamalemontree - 15.02.2023 20:28

This is simple but yet DEADLY! haha thanks much this saved me so much time!

Ответить
Luis Carlos Escobar Arenas
Luis Carlos Escobar Arenas - 27.09.2022 23:37

Super useful tbh!

Ответить
Nic McComb
Nic McComb - 14.09.2022 02:46

Thank you so much, I have been looking for over two days to find the correct way to express what I wanted to do to get a result back that explained how to do exactly this. Your video was concise and so easy to follow and best of all I achieved exactly what I needed to! I cannot thank you enough, so thrilled, thank you Debra

Ответить
H
H - 07.09.2022 07:16

So simple yet amazing. Thank you so much.

Ответить
Henke Levin
Henke Levin - 28.06.2022 14:45

really awesome! Thanks

Ответить
invenew 2018
invenew 2018 - 30.05.2022 08:40

please how could the formula that written in a cell be simultaneously shown in both formula bar and the green text box you inserted in the sheet.
Many thanks for this and all your amazing videos

Ответить
Abuali Alsharif
Abuali Alsharif - 24.04.2022 13:54

Can't thank you enough, it really saved me

Ответить
Life Long Learning
Life Long Learning - 23.04.2022 11:02

Really interesting and neat presentation

Ответить
Monique Jackson
Monique Jackson - 21.04.2022 22:18

This video is INCREDIBLE. This just saved me so much time on my audit. THANK YOU.

Ответить
FoBBiA
FoBBiA - 20.11.2021 05:34

Great tutorial, exactly what I needed and very easily explained.

Ответить
Mohammed Abdullah
Mohammed Abdullah - 09.10.2021 11:47

just what I was looking for.

Ответить
Mohammed Abdullah
Mohammed Abdullah - 09.10.2021 11:46

thanks.

Ответить
Sir_Francis
Sir_Francis - 25.05.2021 18:18

Thank you! that was very well explained & shown!

Ответить
MARK01986
MARK01986 - 18.05.2021 01:32

THANKS A LOT.!!!!

Ответить
Amit Byron
Amit Byron - 07.04.2021 09:39

Thumbs up for a great explanation! Thank you

Ответить
Ron Vanda
Ron Vanda - 23.03.2021 16:25

You save me!
Many thanks for your tutorial :)

Ответить
David Malaka
David Malaka - 18.10.2020 05:02

This was incredibly helpful and your method of showing how to use excel in this context, for this problem was great. Thank you.

Ответить
Vikash Jain
Vikash Jain - 25.09.2020 09:31

Can you please check whats wrong with the formula, I need data in 1 excel file from a separate excel file, your help is much apprecaited.

=INDEX(fo01MAR2019bhav.csv!$I:$I,MATCH(1,(D2=fo01MAR2019bhav.csv!$A:$A)*(E2=fo01MAR2019bhav.csv!$B:$B)*(F2=fo01MAR2019bhav.csv!$C:$C)*(G2=fo01MAR2019bhav.csv!$D:$D)*(H2=fo01MAR2019bhav.csv!$E:$E),0))

Ответить
Ashish Paul Beck
Ashish Paul Beck - 13.08.2020 23:21

I was looking for this for hours thanks a lot <3

Ответить