Formula returning random data

maineL

I have a list of 7 courses and with each course comes specific data.The Tuition Type and SHP Item Type numbers are specific to each course. In this screenshot below, I have the courses in a dropdown list and hoping to populate the SHP Items Type and the Tuition Type columns with their corresponding data. It works for many columns, but for others, it's bringing back data, but not for the correct courses. The formulas I have set up for each are:

SHP: =INDEX({Data SHPType}, MATCH(Course@row, ({Data Course})))

Tuition: =INDEX({Data TuitionType}, MATCH(Course@row, ({Data Course})))

Any ideas? I have MANY different formulas going in this document, but I'm trying to do them one at a time to be sure they're working before moving on. Thank you!

Lori

Paul Newcome

Try specifying an exact match within the MATCH function.

=INDEX({Data SHPType}, MATCH(Course@row, {Data Course}, 0))

Genevieve P.

@maineL

I received your report and the image is removed! 🙂

Paul Newcome

Try specifying an exact match within the MATCH function.

=INDEX({Data SHPType}, MATCH(Course@row, {Data Course}, 0))

maineL

You are AMAZING!!! That worked perfectly. THANK YOU. I'll certainly be back when I run into more issues (not if, but when). 😊 Thanks again! You are awesome!

Paul Newcome

Happy to help. 👍️

maineL

Is there a way I can delete screenshots from my chat now that these have been answered?

Andrée Starå

Hi @maineL

I hope you're well and safe!

Yes, you can click on the flag and select Report and follow the steps.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P.

@maineL

I received your report and the image is removed! 🙂