GrilledCheese
Board Regular
- Joined
- Apr 23, 2014
- Messages
- 75
I have a formula that contains 2 syntax. =INDEX('[Sales.xls]Sheet1'!$A:$A,MATCH($A8,'[Customer.xls]Sheet1'!$A:$A,0)*3,0) What does the * in the formula mean?
I have a formula that contains 2 syntax. =INDEX('[Sales.xls]Sheet1'!$A:$A,MATCH($A8,'[Customer.xls]Sheet1'!$A:$A,0)*3,0) What does the * in the formula mean?
Found answer online. Asterisk matches any sequence of characters. so in my example, *3 means 3 rows down.
It's not matching characters in your formula, it's multiplying the result of the MATCH function by 3. So if MATCH returns 4, you would actually be moving down 12 rows...
I'm confused. What do you mean?