Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels

See how to Create Text Formulas For Finance Tests where you can change the variables PV, APR, Years and compounding periods per year and your Test Text will change automatically. Great Trick for making tests in Excel.
1) (00:51 min mark) Text in double quotes and ampersand (join symbol)
2) (01:43 min mark) DOLLAR function
3) (03:41 min mark) TEXT function
4) (05:40 min mark) VLOOKUP function

[binyaminschwartz]

Very happy to see you back on the air. Best wishes.

[emanalbar]

i glad that you're back Mike.  Thank you for this great video. 

[Poprasstriga]

Welcome back, Mike!
Waiting for your powerpivot series, don't put it off for long!

[waellerbe]

I love to tune into videos like this which help to *talk* us through the instruction of Excel.

[TickyMN]

Wow...I've done things similar to that but the "Dollar" and "Text" functions make it so much easier than what I've been doing.  Thanks again Mike!

[excelisfun]

Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels 

See how to Create Text Formulas For Finance Tests where you can change the variables PV, APR, Years and compounding periods per year and your Test Text will change automatically. Great Trick for making tests in Excel.
1) (00:51 min mark) Text in double quotes and ampersand (join symbol)
2) (01:43 min mark) DOLLAR function
3) (03:41 min mark) TEXT function
4) (05:40 min mark) VLOOKUP function

[excelman]

Probably be good to include data validation to ensure that 1)PV is not negative, and 2) the period is one of the numbers within the first column of the period table.

[bosem]

i became addicted on those formula, thanks you teach me alot… i have favor to ask i want to know how to make link excel to access that any data enterd in excel automatically stored in access database, , thx again

[masumabegum]

Hello

I've only just started to follow you. Great videos and tips, but is there a reason why it's fuzzy?

[kristinanordell]

Do you ever answer questions for people? I am a teacher trying to create a data sheet and need a way to graph specific data. I essentially need to drag a pattern that makes consecutive cells equal to the contents of every other cell on another part of the sheet. For example: Cell AY10 =A10, Cell AY11 =A12, Cell AY12 =A14. Is there any way to write a formula for this? When I drag the pattern, it just copies what I wrote.

[masem]

Is there a way to have excel take 3 values from 3 separate cells (side by side) and search for matching values in another list? the other list will have the same 3 consecutive cells.

[bosem]

i became addicted on those formula, thanks you teach me alot… i have favor to ask i want to know how to make link excel to access that any data enterd in excel automatically stored in access database, , thx again