index match quandary
I'm using this formula to return a student specific date from another sheet based on a student code
=INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet})
it says #INVALID DATA TYPE
I've used this INDEX MATCH and this type of formula before and I'm not sure why its not working
Best Answer
-
Make sure you are using columns that are set as date type both in the source sheet and the target sheet.
Answers
-
It looks like you may be missing the MATCH function.
=INDEX({Range to pull from}, MATCH([Student Code]@row, {Student Code}, 0))
-
@Paul Newcome yeah thanks,
I thing I tried a bunch of times with the index match formula and coudn't get it right so i ended up seeing if just the just the index formula would work.
the INDEX MATCH format you sent appears to be right, but im not sure which sheet to reference for the "range to pull from" and for the "student code". Here i referenced the info sheet date column as the range to pull from and the student code column from the same info sheet. the sudent code@row is from the cell right next to where I want to return the date in the same sheet.
=INDEX({IEP date from info Sheet}, MATCH([Student Code]@row, {Student Code from info sheet}, 0))
this version returns an #INVALID COLUMN VALUE
-
=INDEX({IEP date from info Sheet}, MATCH([Student Code]@row, {Student Code from info sheet}, 0))
gives me: #INVALID COLUMN VALUE
=INDEX({Student Code from info sheet}, MATCH([Student Code]@row, {IEP date from info Sheet}, 0))
Gives me #NO MATCH
I'm just struggling with the syntax i suppose
-
this is the working version of the same formula in my sheet, referencing the same sheet and codes
=INDEX({IEP Status from info sheet}, MATCH([Student Code]@row, {Student Code from info sheet}, 0))
this one reflects the IEP status from the info sheet and references the same student code.
but when i use the same exact formula format but reference the IEP date column instead of the IEP status it gives me the Error #INVALID COLUMN VALUE
-
Make sure you are using columns that are set as date type both in the source sheet and the target sheet.
-
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 142 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!