INDEX MATCH MATCH

INDEX MATCH MATCH

Say you want to pull a value from a table based on inputs cells. Both the row and column choices are dependent upon those inputs.

Example:

You have a list of food items in column A. Prices for those items are dependent on the month, January-December, and are listed in columns B-M. You want to be able to set up input cells were you could choose to lookup, say, the price of bananas in March. How can you do this?

INDEX MATCH MATCH

= INDEX ( entire matrix , MATCH ( vertical lookup value,  entire left hand lookup column , 0 ) , MATCH ( horizontal lookup value , entire top header row , 0 ) )

Learn more about it here:
http://www.mbaexcel.com/excel/how-to-use-index-match-match/

Not really an Excel tip...

This can be used in any Office program, to add a little zing to whatever you are creating. Have you ever wanted to create a number in a circle? Windings 2  is your answer:

http://speakingppt.com/2011/10/24/cheat-sheet-for-creating-numbers-inside-circles/

BTW, am I the only one who always says WingDings?

Search terms and phrases:
Number in Circle
Windings font

VBA for Various Copy/Paste Functions

I've been playing around with VBA a bit for a model I'm building. I needed a quick reference for various copy/paste functions, and found this website to be very helpful and easy to follow:

https://support.microsoft.com/en-us/kb/291308

Which is unusual, seeing how it's just the MS website. Still worth a look!

Search terms and phrases:
VBA
Copy Paste Range