Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 1 of 2

[@Arroyoale1]

You are a GREAT teacher ! I loved the 'relaxing session' ! great thanks so much

[@chuckditto3285]

I understand your explanation of the VLookup function and I learned how to use the VLOOKUP function using your examples-when it works-that's as good as it gets.

[@itsmarialifestyle4355]

Your tutorial is nice and clear. In speech and picture, very helpful, thank you.

[@GermantownFamily]

You saving my life. excellent

[@warren218]

Very well explained - don't know whether I'll need it for work but good to know. Good software used to highlight bits

[@LinaVera4]

THANK YOU SO MUCH this really helped me

[@frank299]

Great Video. Thanks!
What if the name I needed to look up (step 1) was based on the combination of 2 columns? (Row is not uniquely identified by a single column)
Example: Lookup the 'Value Amount' based on the combination of 'Ticker Symbol' & 'Portfolio' (each row is unique by Ticker Symbol\Portfolio)?

[@mazher1934]

Can you please help me with macro , which find a cell with value "Force" (Row and column)and them copy all the cells in that column in to assigned column ,neglecting all the empty cells if any
I would really appreciate if you can help me with this.
Thanks in advance

[@krutikasatapathy6482]

Whats the formula for col_index_num?

[@MrEms333]

i try to make same as you make and give me error can you make it for me i can send to you my list

[@hukogrebo]

The formula in the first example is incorrect Gordon should be between Quotation Marks...

[@cupidjaison]

check once in excel before showing like this