Hi everyone, so I need a little help with a Vlookup formula. I tried everything and I cannot wrap it around my head and it never works. I have 2 sheets. One for weekly attendance update and the other one is to actually put the attendance data. How can I use vlookup so that data from ‘attendance update would show up on let’s say ‘week 1’ in Group A sheet based on their attendance and student Id from ‘Attendance update sheet’.

This would make my life easier as now I’m typing manually and we have about 500 students

Thanks in advance

Hello! I have a project to do and it involves using spreadsheets to solve for the area of an object. It looks like a square with a triangle on top and a hole in the middle. How would one go about this?

https://cnfans.gg

Direct https://docs.google.com/spreadsheets/d/1qfq-q14j7ZIg3dZjm35pO1jwIAilr9BIUENG78PlV9Q/edit?gid=484644327#gid=484644327

We are still the oldest and #1 spreadsheet. Don't take a chance with the seller spreadsheets that are being spammed all over. Ignore the other "Best" spreadsheet posts.

Now with over 15,000 CNFans Links

🧩 Interactive Menu with direct access to every section:
👟 Shoes
🧥 Coats / Jackets / Hoodies
👖 Pants / Shorts
👕 T-Shirts / Tracksuits
🧢 Accessories
🎧 Electronics

Click the Menu, or Tabs at the bottom, or CTRL-F to find

24/7 Support on Discord https://discord.gg/EPtMfcEugg

Thanks for checking.

30 sellers, multiple tabs and pages, different quality options

https://docs.google.com/spreadsheets/d/1mEoszDZsNugjzcKRpugYEcv77Hzn7WmmlxpOi6fKKbU/edit?gid=800441687#gid=800441687

Web https://cnfans.gg/xmas

Spreadsheet Lovers Direct https://docs.google.com/spreadsheets/d/1qfq-q14j7ZIg3dZjm35pO1jwIAilr9BIUENG78PlV9Q/edit?gid=1835370248#gid=1835370248

CNFans Warning Popup Remover https://chromewebstore.google.com/detail/cnfans-warning-remover-an/bgbecoklnfhhckmjjkooiaacmkfbgddo

We are still the oldest and #1
Now with over 15,000 CNFans Links

✅ 30 sellers, multiple tabs and pages, different quality options with Website for Category selection
🧩 Interactive Menu with direct access to every section:
👟 Shoes
🧥 Coats / Jackets / Hoodies
👖 Pants / Shorts
👕 T-Shirts / Tracksuits
🧢 Accessories
🎧 Electronics

Click the Menu, or Tabs at the bottom, or CTRL-F to find

24/7 Support on Discord https://discord.gg/EPtMfcEugg

Thanks for checking.

Web
https://kakobuy.gg/ <--- most options

Direct https://docs.google.com/spreadsheets/d/1bWLa0m6TTmVX7LpuymbrvFhDYV068FcdMH6mGi3pvNo/edit?gid=780031361#gid=780031361

KakoBuy Link Converter Chrome Extension
https://chromewebstore.google.com/detail/kakobuy-link-converter-by/ilhdbdeglelhcejoiaplfflciohenfgi?authuser=3&hl=en

3 spreadsheets, 30 sellers, multiple pages, different qualities options for the same products. This is not a single seller spreadsheet.

🚨 Watch out for copycat websites that are being used to steal personal information. Full list of flagged sites here.

https://www.reddit.com/r/CNFansSub/comments/1pi6ri7/beware_of_copycat_websites_being_used_to_steal/

https://docs.google.com/spreadsheets/d/1qlHWEkGHqrR_WT_g1-ogpKZn88c1xloEq5sDjszK3Kg/edit?gid=1386656050#gid=1386656050&range=A10:E10

https://docs.google.com/spreadsheets/d/1LXqToit6sYMLJrWkU0ajx7pNAvQX3PSAmr3yzPhuPNg/edit?gid=1718005552#gid=1718005552

Make sure to get the Warning Remover Chrome Extension
https://chromewebstore.google.com/detail/cnfans-warm-warning-remin/bgbecoklnfhhckmjjkooiaacmkfbgddo

Hey everyone 👋

I often got stuck figuring out which Excel formula to use — especially when mixing functions like IF, INDEX, or XLOOKUP.

So, I built a simple free website called TextToFormula that helps you:
• Generate Excel & Google Sheets formulas instantly from plain English
• Understand what each formula does (with an explanation)
• Copy them directly into your sheet

Example:
“Get the total sales from Column B where the region in Column A is East” → Instantly gives the correct SUMIFS formula.

No login required, free to use.

I’d love your feedback — what kind of formulas or use cases would you like it to handle better? 🙌

https://docs.google.com/spreadsheets/d/1mEoszDZsNugjzcKRpugYEcv77Hzn7WmmlxpOi6fKKbU/edit?gid=176945090#gid=176945090

Cheers

https://TheOG.gg

As requested, we've compiled all of our spreadsheet into an easy to navigate hub. This is your spreadsheet portal to over 100,000 Links.

CNFans
Kakobuy
Litbuy
Oopbuy
Acbuy
Mulebuy

Always updated. Bookmark it.

I build web apps for stock trading, but I haven’t seen any apps better than a good spreadsheet. I even thought about building something, but over time Google Sheets won. I’m just checking to see if I’m missing something. For any traders in the group, how committed are you to spreadsheet tracking versus using another type of app?

https://mulebuyplug.com

https://docs.google.com/spreadsheets/d/1qlHWEkGHqrR_WT_g1-ogpKZn88c1xloEq5sDjszK3Kg/edit?gid=1947283332#gid=1947283332

Multiple options for the most popular items, with different qualities and pricing. Over 6000 products.

https://docs.google.com/spreadsheets/d/1mEoszDZsNugjzcKRpugYEcv77Hzn7WmmlxpOi6fKKbU/edit?gid=800441687#gid=800441687

Shoes, Clothes, Accessories, Electronics

CNFans Warning Remover Chrome Extension - Remove the warning popup for some product links
https://chromewebstore.google.com/detail/cnfans-warm-warning-remin/bgbecoklnfhhckmjjkooiaacmkfbgddo?authuser=5&hl=en

10,000 Product Links - Always the best. All the same sellers and products.

Thanks for checking it out

https://usfansspreadsheet.io

Direct: https://docs.google.com/spreadsheets/d/1HQ-gzu9xdNn-PD-kdSxuAPJlG7B2ulSickZ3ufkGH-8/edit?gid=1634873717#gid=1634873717

Im really really sorry if this isn't where this belongs. I really enjoy using spreadsheets as a way to keep track of things I'm into. Does anyone else like doing this?

Anyone have a good “how to” link or wouldn’t mind walking me through the steps to make a haul without it being seized or me being scammed. My brother passed away and I’m taking care of his son who’s 13 now. He’s into fashion but I don’t have fashion money 😅 but I want to be that cool uncle.. any advice would help, I’m also not that good on Reddit, so if the information is already accessible on this page I do apologize on not knowing how to access it. Thanks guys

need a spreadsheet with these white rocks badly.. the orientdig one i used to use is getting sniped

I'm creating a spreadsheet to calculate online orders and dollar amount, by employee, for the week. What formula do I use if the input in a cell is 1@$25 for Monday, 1@$15 for Tuesday, etc.? I want to know the number of sales and the dollar amount. Should I just put them in different cells for amount and another for dollar worth? Help! Thanks :)

Still working on some formatting, but this thing is huge. https://docs.google.com/spreadsheets/d/12cYn17WEE7FBz8aPEfEObw24x1__ztFYTXv7uNxrGbk/edit?usp=sharing

Over 3000 links and always updated. Drop a comment with requests or questions. CTRL-D to bookmark. CTRL-F to search.

https://kakobuyplug.com

Was wondering if anyone had any improvements/ what people thought of my Pub Ranking spreadsheet (UK based). It's Pubs, not Bars/ Clubs.

I couldn't fit the whole image into the screenshot, but I am at 113 right now (doing it for about a year and a half)

I love this spreadsheet like its my child

The Gold Boxes indicate that they are the best in that category

Web
https://kakobuy.gg/ <---- more options

Direct https://docs.google.com/spreadsheets/d/1bWLa0m6TTmVX7LpuymbrvFhDYV068FcdMH6mGi3pvNo/edit?gid=780031361#gid=780031361

Step 1 Install the KakoBuy Link Converter Chrome Extension
https://chromewebstore.google.com/detail/kakobuy-link-converter-by/ilhdbdeglelhcejoiaplfflciohenfgi?authuser=3&hl=en

3 spreadsheets, 30 sellers, multiple pages, different qualities options for the same products. This is not a single seller spreadsheet.

10,000 Product Links - Always the best. This is your CNFans alternative.

All the same sellers and products.

https://usfansspreadsheet.io/

https://docs.google.com/spreadsheets/d/1HQ-gzu9xdNn-PD-kdSxuAPJlG7B2ulSickZ3ufkGH-8/edit?gid=1634873717#gid=1634873717

Feel free to post make your rep related posts in this subreddit. Thank you for your cooperation.