Use the match function to find number in list in Excel

Use the match function to find a number in a list.
Finding matching numbers. Excel,
Check out my templates page for free and purchased templates www.easyexcela...
Are you struggling to update your Microsoft SQL Server data?
I recommend using well-known Excel to update and manage your data in SQL Server using the SQL Spreads Excel add-in.
Click sqlspreads.com... to find out how SQL Spreads works best for non-technical end users and download our free 14-day trial. You will get two months free when purchasing an annual subscription using our link.
For more help visit my website www.easyexcelan... or email me at [e-mail].
Become an Affiliate and earn 25% on Course Sales
barb-s-school-...
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
www.amazon.com...
Check out my next one-hour Excel Webinar
www.crowdcast....
I use a Blue condensor Microphone to record my videos, here is the link
amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
app.linkmink.c...
If you need to buy Office 2019 follow
amzn.to/2VX5dv8
I use Tube Buddy to help promote my videos
Check them out
www.Tubebuddy....
Follow me on Facebook
/ easyexcel.answers
TWEET THIS VIDEO • Use the match function...
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
www.youtube.com...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.

[@Samantha-gr1bg]

Thanks, just what i was looking for!

[@BarbHendersonconsulting]

Glad I could help!

[@sj9339]

This is very helpful. Thanks for sharing!

[@BarbHendersonconsulting]

Glad it was helpful!

[@jeffstevenson8027]

thank you so much, this was sooo helpful.

[@BarbHendersonconsulting]

Happy I could help

[@HariKrishnan-ci5ub]

Wow I'm impressed!!!!!!super!!!!!!

[@BarbHendersonconsulting]

Thank you! Cheers!

[@keopanharapy3826]

Thank Q, Its work and easy way of formula function.

[@BarbHendersonconsulting]

Glad to hear that

[@Jojomob.]

OMG it worked. Thanks!!!

[@DM43685]

Thank you, Thank you .... Thank you

[@BarbHendersonconsulting]

You are very welcome

[@gloria770]

Thank you 😊

[@BarbHendersonconsulting]

You're welcome 😊

[@Alyanna-g6k]

How about if there is a multiple number in a cell? Example (563, 253), 253 is in the list. How to show, Yes?

[@BarbHendersonconsulting]

the match function would not be suitable for that

[@nirmal148]

super helpful

[@BarbHendersonconsulting]

Glad to hear!

[@rebeccaromero6086]

I tried to do this however it doesn't seem to work, however my column B is not as long as column A.

[@abdullah.m8220]

Really appreciate

[@BarbHendersonconsulting]

Your welcome

[@baileytales7207]

Thankyou mam v helpful

[@BarbHendersonconsulting]

Most welcome 😊

[@bayadm]

Impressive !

[@BarbHendersonconsulting]

thank you

[@HerewardDundasTaylor]

I have a word document that contains several hundred WWII army serial numbers in the text and I have an XL document with about 35,000 Army Serial Numbers. I want to find what serial numbers in XL are also in the word document or vice versa. Can this be automated?

[@BarbHendersonconsulting]

I am not sure that would involve VBA with Word which is not my I do not know much about

[@sunithasurampalli]

What if any of the value is there for multiple times in any of the column

[@BarbHendersonconsulting]

it will find the first

[@Ravikumar-gg1ov]

Super I got the answer

[@m.night_shyamamalama_sama_kun]

Lovely, tho u do sound fed up with life, hope all is well

[@rebekahmckiernan888]

I have a list of unique values I need to find in a column 90k rows in length. I have used the Conditional firmatting but it's so slow. Is there any way I can quickly find the values and delete the entire rows with those values?

[@BarbHendersonconsulting]

Have you seen this video, ruclips.net/video/Kv0r7eFLyEo/видео.html It might be what you need

[@karthikh8477]

Need to freeze selected columns.. else it will just go down as you copy forumals..

[@BarbHendersonconsulting]

no, double click the fill handle and it should work.

[@Amsamuels248]

I found out that if you put $A$2:$A$650 it doesn't shift the data that you are search. I hope this helps someone.

[@Dopeboyz789]

What if you have multiple columns or rows

[@BarbHendersonconsulting]

You would have to create if for each column

[@Dopeboyz789]

@@BarbHendersonconsulting how do I do that

[@Dopeboyz789]

@@BarbHendersonconsulting what if I do it from different tables

[@7mdn_AUH]

Cntrl+f?

[@BarbHendersonconsulting]

short cut to find

[@adityabodhe3340]

why not $?

[@BarbHendersonconsulting]

I think you could have $ as long as you have them on both lists

[@Afroamerinegro]

How can we use this but instead of yes/no, I want it to highlight the original match

[@BarbHendersonconsulting]

I don't think you are able to do that with the match function

[@HussamQazi]

Hi. I a number that I need to find in a column. which is clubbed amount of 2 numbers or more in another table. How I can find that numbers? Like I want to find what numbers are adding up to make $3000. is there any way?

[@BarbHendersonconsulting]

I would not know where to start on that one!