Configuring proper syntax for multiple-worksheet and criteria using INDEX-MATCH, and others

		Microsoft Office Forums > Microsoft Excel > Excel
Configuring proper syntax for multiple-worksheet and criteria using INDEX-MATCH, and others

FAQ

Thread Tools

Display Modes

12-04-2016, 11:10 PM

xor

Windows 10 Configuring proper syntax for multiple-worksheet and criteria using INDEX-MATCH, and others

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,100

I am not sure what it is that you want, but if it is to extract the number at the right of the string in Track Table!D2 you can use:

=LOOKUP(9^9,-RIGHT(D2;ROW($1:$100)))

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Index Match syntax	grexcelman	Excel Programming	0	03-05-2015 07:17 AM
UDF multiple IFs INDEX-MATCH	grexcelman	Excel Programming	0	02-22-2015 04:20 PM
Entering proper syntax to SKIP unwanted Records	jp91306	Mail Merge	1	04-14-2014 03:15 PM
Help with multiple match and index formula	ryanwood	Excel	1	09-12-2012 07:53 AM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:19 AM.