Home |
Search |
Today's Posts |
#7
![]() |
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result | Excel Worksheet Functions | |||
Find Exact Match using INDEX, MATCH | Excel Worksheet Functions | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions |