Populate Mark Phone Number with airSlate SignNow

Collate numbers voucher

Hi, this is Gary with MacMost.com. Let's look at the incredibly, useful INDIRECT function in Numbers. MacMost is brought to you thanks to a great group of supporters. Go to Macmost.com/patreon. There you can read more about it, join us and get exclusive content. So you can accomplish a lot in a Numbers spreadsheet using something like the Lookup function. But the INDIRECT function can actually be more powerful. You can do some really clever things with it. Here's the basic way that INDIRECT works. Say I want to get the value of apples at the Central store which is sixty cents. I could go into a cell here, type the equals key to enter a formula mode, and I could type C2 and hit Return. It's going to covert that to Central Apples because that's the name of the row and column and it will give me that value. I could also just have typed equals and then clicked here and I get that. I can use INDIRECT to get that in an indirect way. So I'll enter a formula and do Indirect as the function and parenthesis. Then I can do in quotes something like C2. Then I also get that same value. So it's basically saying okay do an Indirect lookup of this string, this piece of text here C2, what's the value of C2. Okay. Now that may not seem like it's an improvement over this. This seems a lot easier. But now you can do things like this. You can say Indirect and say give me the Indirect value of whatever the value in this cell is. B10. I close it and I get an error because B10 is empty. But if I enter the text C2 into B10 I get $0.60 because it's saying INDIRECT lookup of the value of B10 which is C2 and it looks up that value. If I change this to say C3 you can see it goes and says $0.65 because now it's looking up Central Oranges. So you can use INDIRECT to grab a value from one place and then find the value based on the first value, there. You can do that in another table as well. You just need to add the table name. So I could right here say INDIRECT and then in quotes you could say prices, since that's the name of this table here, two colons, and then I could say C2. It will get me that value. Now things get really interesting when you start to use row and column names instead of a labels like C2. So, for instance, I can do INDIRECT and instead of C2 I can simply say, okay Central Apples and it will give me the value. I can do the same thing here. I can say Prices colon colon Central Apples and it will look it up. As a matter of fact it's even smarter than that because I don't need to include the name of...