index match quandary

Dell55

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

Find more posts tagged with

Healthcare

Formulas

Accepted answers

Paul Newcome

Make sure you are using columns that are set as date type both in the source sheet and the target sheet.

All comments

Paul Newcome

It looks like you may be missing the MATCH function.

=INDEX({Range to pull from}, MATCH([Student Code]@row, {Student Code}, 0))

Dell55

@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

Dell55

=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

Dell55

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

Paul Newcome

Make sure you are using columns that are set as date type both in the source sheet and the target sheet.

Dell55

@Paul Newcome

THAT WAS IT !...

Thanks Paul!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.