Results 1 to 17 of 17

INDEX MATCH MATCH statement to look up the 1st occurrence, 2nd occurrence in a single cell

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Switch to Hybrid Mode
- Threaded Mode

Threaded View

08-16-2019, 02:07 AM #7
Success4me

View Profile

View Forum Posts
Registered User

Join Date

05-26-2018

Location

London,England

MS-Off Ver

2016

Posts

18
Re: INDEX MATCH MATCH statement to look up the 1st occurrence, 2nd occurrence in a single

I know i have to use INDEX, MATCH and SMALL, ROW functions but how. The workbook by MLOOKUP does not help
Register To Reply

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

nth occurrence with multiple criteria (index/match)

By Hlech989 in forum Excel General

Replies: 3
Last Post: 03-08-2019, 03:46 AM
Index, match, smalls to return nth occurrence of value in row and display column header

By sirloin16oz in forum Excel Formulas & Functions

Replies: 2
Last Post: 03-07-2019, 07:29 PM
Index match nth occurrence or just get nth match

By sdl2 in forum Excel General

Replies: 10
Last Post: 05-21-2018, 09:59 AM
Finding Second Occurrence if Index Match Returns -

By zmster2033 in forum Excel Formulas & Functions

Replies: 8
Last Post: 03-22-2016, 02:50 PM
Using index and match to return a value based on earliest occurrence (MONTH)

By potatoman in forum Excel Formulas & Functions

Replies: 10
Last Post: 09-09-2014, 06:12 AM
Using index and match to return a value based on earliest occurrence (MONTH)

By potatoman in forum Excel Formulas & Functions

Replies: 2
Last Post: 09-06-2014, 06:16 AM
[SOLVED] Index Match row value and nth occurrence of header

By dm@stams in forum Excel Formulas & Functions

Replies: 2
Last Post: 03-22-2013, 05:43 PM

Bookmarks

Bookmarks

Posting Permissions

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 04:22 PM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1