 **Function Type:** Lookup and Reference **Description:** INDEX function returns the value of a given location in a table range or array. This function is commonly used with MATCH function which give us the location of the lookup_value. **Function Structure:** =INDEX(*array, row_number, [column_number]*) **Argument Breakdown:** *array* - This is the group of cells where your excel will look into. *row_number* - This is the row location in your array. This argument requires a number input. A function that returns a number such as MATCH can also be used here. *[column_number]* - This is the column location in your array. This argument requires a number input. A function that returns a number such as MATCH can also be used here. Example:  Say we want to look into the Price of the Tool Box,Β The formula will be =INDEX(A2:C8,6,2) This means that Excel will return the value in the intersection of 6th row and 2nd column of the array A2:C8. To make it more dynamic like a vlookup, we can pair it with MATCH function. --- Still need help with Excel and Google Sheets? [Get Instant Expert Help](https://www.fiverr.com/share/ey8E6m) We can also accept LEO, HIVE, HBD tokens as payment. --- This post is designated as a reviewer for Excel trainings I conduct. Feel free to share with anyone. π Earnings from Upvotes on this post are used to continue sharing Excel knowledge. If you also want to earn [HIVE](https://leopedia.io/hive/) in 7 days while blogging your favorite topics, join us here at [Peakd](https://peakd.com/register?ref=cashheaven). *Thumbnail used is made in Canva.
author | excelsheets |
---|---|
permlink | index-function |
category | hive-167922 |
json_metadata | {"app":"leofinance/0.2","format":"markdown","tags":["excel","sheets","neoxian","functions","formula","education","mancave","excelforall","leofinance"],"canonical_url":"https://leofinance.io/@excelsheets/index-function","links":["https://www.fiverr.com/share/ey8E6m","https://leopedia.io/hive/","https://peakd.com/register?ref=cashheaven"],"image":["https://images.hive.blog/DQmPxoSeducfKAJmbikdYLRJtxKrea8K1jfVJPPChSpU2MJ/INDEX%20Function.png","https://images.hive.blog/DQmY1AWJmoQZJ6p3oiRdSCsipe3RZmhqEkdc11mf9Kd3A4b/image.png"]} |
created | 2022-12-19 09:25:48 |
last_update | 2022-12-19 09:27:54 |
depth | 0 |
children | 2 |
last_payout | 2022-12-26 09:25:48 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.250 HBD |
curator_payout_value | 0.248 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 1,813 |
author_reputation | 1,449,141,605,578 |
root_title | "INDEX function" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 119,223,443 |
net_rshares | 1,241,932,885,087 |
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
team | 0 | 142,798,318,409 | 20% | ||
droida | 0 | 92,432,340,781 | 100% | ||
roleerob | 0 | 2,254,456,561 | 0.24% | ||
basterundco | 0 | 3,493,202,939 | 100% | ||
freebot | 0 | 101,361,806 | 100% | ||
lunapark | 0 | 94,274,475 | 100% | ||
quicktrade | 0 | 96,202,051 | 100% | ||
cresus | 0 | 459,331,393 | 100% | ||
hadaly | 0 | 94,264,475 | 100% | ||
goldfoot | 0 | 490,927,421 | 100% | ||
dotmatrix | 0 | 94,428,647 | 100% | ||
otomo | 0 | 94,208,681 | 100% | ||
botito | 0 | 94,297,576 | 100% | ||
weebo | 0 | 94,174,941 | 100% | ||
freysa | 0 | 94,190,779 | 100% | ||
tobor | 0 | 94,218,485 | 100% | ||
buffybot | 0 | 94,951,793 | 100% | ||
hypnobot | 0 | 95,031,167 | 100% | ||
psybot | 0 | 95,534,532 | 100% | ||
psychobot | 0 | 94,928,549 | 100% | ||
curabot | 0 | 94,196,484 | 100% | ||
elector | 0 | 92,545,099 | 100% | ||
chatbot | 0 | 95,001,468 | 100% | ||
chomps | 0 | 94,256,103 | 100% | ||
quicktrades | 0 | 6,266,965,858 | 100% | ||
misery | 0 | 96,968,064 | 100% | ||
swissbot | 0 | 96,436,592 | 100% | ||
bilpcoin.pay | 0 | 535,385,845 | 10% | ||
brofund | 0 | 557,430,202 | 1.2% | ||
ukulima | 0 | 67,758,533,237 | 5% | ||
honeybot | 0 | 946,285,036 | 100% | ||
brofi | 0 | 153,408,827,939 | 1.2% | ||
nfttunz | 0 | 9,654,538,422 | 0.6% | ||
cashheaven | 0 | 64,245,866,942 | 100% | ||
waivio.welcome | 0 | 1,175,867,657 | 2.21% | ||
waivio.com | 0 | 789,294,695 | 2.21% | ||
carcio84 | 0 | 593,292,052,988 | 100% | ||
alg-nftgaming | 0 | 94,646,058,114 | 100% | ||
dtake | 0 | 3,235,476,879 | 100% | ||
apfelkeks | 0 | 1,590,252,002 | 100% |
Congratulations @excelsheets! You have completed the following achievement on the Hive blockchain And have been rewarded with New badge(s) <table><tr><td><img src="https://images.hive.blog/60x70/http://hivebuzz.me/@excelsheets/upvoted.png?202212192249"></td><td>You received more than 400 upvotes.<br>Your next target is to reach 500 upvotes.</td></tr> </table> <sub>_You can view your badges on [your board](https://hivebuzz.me/@excelsheets) and compare yourself to others in the [Ranking](https://hivebuzz.me/ranking)_</sub> <sub>_If you no longer want to receive notifications, reply to this comment with the word_ `STOP`</sub> **Check out our last posts:** <table><tr><td><a href="/hive-102201/@hivebuzz/wc2022-recap-final-day2"><img src="https://images.hive.blog/64x128/https://i.imgur.com/uNPMgnd.png"></a></td><td><a href="/hive-102201/@hivebuzz/wc2022-recap-final-day2">HiveBuzz World Cup Contest - Recap of the Final</a></td></tr><tr><td><a href="/hive-139531/@hivebuzz/proposal-2324"><img src="https://images.hive.blog/64x128/https://i.imgur.com/RNIZ1N6.png"></a></td><td><a href="/hive-139531/@hivebuzz/proposal-2324">The Hive Gamification Proposal Renewal</a></td></tr></table> ###### Support the HiveBuzz project. [Vote](https://hivesigner.com/sign/update_proposal_votes?proposal_ids=%5B%22248%22%5D&approve=true) for [our proposal](https://peakd.com/me/proposals/248)!
author | hivebuzz |
---|---|
permlink | notify-excelsheets-20221219t233712 |
category | hive-167922 |
json_metadata | {"image":["http://hivebuzz.me/notify.t6.png"]} |
created | 2022-12-19 23:37:12 |
last_update | 2022-12-19 23:37:12 |
depth | 1 |
children | 0 |
last_payout | 2022-12-26 23:37:12 |
cashout_time | 1969-12-31 23:59:59 |
total_payout_value | 0.000 HBD |
curator_payout_value | 0.000 HBD |
pending_payout_value | 0.000 HBD |
promoted | 0.000 HBD |
body_length | 1,388 |
author_reputation | 369,397,183,320,581 |
root_title | "INDEX function" |
beneficiaries | [] |
max_accepted_payout | 1,000,000.000 HBD |
percent_hbd | 10,000 |
post_id | 119,239,784 |
net_rshares | 0 |
https://twitter.com/1585112629835870211/status/1604895381518966785 <sub> The rewards earned on this comment will go directly to the people( @excelsheets ) sharing the post on Twitter as long as they are registered with @poshtoken. Sign up at https://hiveposh.com.</sub>
author | poshtoken | ||||||
---|---|---|---|---|---|---|---|
permlink | re-excelsheets-index-function-1341 | ||||||
category | hive-167922 | ||||||
json_metadata | "{"app":"Poshtoken 0.0.1","payoutToUser":["excelsheets"]}" | ||||||
created | 2022-12-19 17:47:45 | ||||||
last_update | 2022-12-19 17:47:45 | ||||||
depth | 1 | ||||||
children | 0 | ||||||
last_payout | 2022-12-26 17:47:45 | ||||||
cashout_time | 1969-12-31 23:59:59 | ||||||
total_payout_value | 0.000 HBD | ||||||
curator_payout_value | 0.031 HBD | ||||||
pending_payout_value | 0.000 HBD | ||||||
promoted | 0.000 HBD | ||||||
body_length | 270 | ||||||
author_reputation | 5,378,745,118,124,503 | ||||||
root_title | "INDEX function" | ||||||
beneficiaries |
| ||||||
max_accepted_payout | 1,000,000.000 HBD | ||||||
percent_hbd | 0 | ||||||
post_id | 119,231,923 | ||||||
net_rshares | 158,115,906,653 | ||||||
author_curate_reward | "" |
voter | weight | wgt% | rshares | pct | time |
---|---|---|---|---|---|
cashheaven | 0 | 64,122,754,854 | 100% | ||
alg-nftgaming | 0 | 93,993,151,799 | 100% |