About Us

Mazzaropi

Quote:

Originally Posted by BillA

Thanks for the help everyone! I truly appreciate it.

What I ended up find that worked was
=INDEX($1:$1,MATCH(9.99999999999999E+307,2:2))

For comparison, I had been trying
=INDEX($1:$1,MATCH(1,2:2))
So for Song A (the first song) which is in row 2 (the titles are in row 1) if I use the above formula, it works. I don't know why searching for a very large number, vs searching for a 1 works.... but it does.
Thanks for the help!

BillA, Good Morning.

I don´t understand why you need use this formula that you mentioned.

My formula works well BUT the formula that zvkmpw suggested is BETTER and EASIER to understand than mine. It´s brilliant!
YOU can use it easily.
I applied this formula to my example and I sending to you again.

It sounds that your real worksheet have a different layout that I understood.
Please, zip your worksheet and attach it here.
It will be possible to analyse and discover what is the real problem.

Have a nice day.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result	io	Excel Worksheet Functions	0	February 23rd 13 09:08 AM
Find Exact Match using INDEX, MATCH	DoubleUU	Excel Worksheet Functions	3	August 15th 08 02:42 PM
index(match) Wind Uplift Calculations (match four conditions)	JMeier	Excel Worksheet Functions	8	August 1st 08 01:45 AM
index match array function-returning only first match, need last.	Julie Olsen	Excel Worksheet Functions	3	December 29th 06 12:50 AM
How do I display more than one match in a Index/Match formula?	Trish	Excel Worksheet Functions	0	September 26th 05 10:21 PM

Menu

About Us