Forum Discussion
Excel formulas
I am trying to pull a row number that is associated with a student record into a formula in a second sheet. The names are alphabetical in one and by classroom in the other
mathetes Awesome! I got the range to work in my original one Yours looks great and can't wait to use it I can't thank you enough for all your help. Your a godsend 🙂
Mary
You're very welcome, Mary. I love using Excel (much prefer designing a spreadsheet to playing computer/video games)...and am learning since joining this site last week, just a day or two before you did, that Excel has added features in the last decade or more that I didn't know about (I retired in 2002 and have continued using Excel personally, but not keeping up on all the changes)...
Anyway, feel free to come back with questions about the solution I've given you. Depending on the volume of lunch purchases, the number of students, etc., there are surely more elegant ways to meet your needs. I have some ideas, but they'd involve major changes that may not be worth it in your situation.
John (mathetes)
Anyway, feel free to come back with questions about the solution I've given you. Depending on the volume of lunch purchases, the number of students, etc., there are surely more elegant ways to meet your needs. I have some ideas, but they'd involve major changes that may not be worth it in your situation.
John (mathetes)
- If you're only getting a "few N/As" that suggests possibly the SchoolIDs aren't being found for those few students. Off hand I can't think of another cause for that. One of the essential parts of a viable database is a reliable and consistent "key"--otherwise known as a unique identifier. Sometimes, even as simple a matter as an extra (but invisible) space in the field of one or the other of the two spreadsheets entries for that field..... so check the SchoolID field for those few N/A cases...to make sure they're identical even to the point of having no "trailing space" after the last digit. The VLOOKUP is looking for an EXACT match.
mathetes my school has a new billing program which isn't the end all be all so i am trying to get my spreadsheet working which has always worked great for me. Lot of catch up but it will be worth it. I also actually spoke to soon. When i cut and pasted the VLOOKUP formula I am seeing a few N/A's Can't figure out where the error is