• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Index and Match Help

LaurenL

New Member
Hello,

I will start off by saying I am an avid VLookup user. I am learning to use Index and Match more frequently and hopefully be just as comfortable. However, I am in need of help during this learning curve.

I have a worksheet to track tickets that have been submitted- tickets are submitted based on a referenced document number. What I am having difficulty with is - one ticket submitted could have more than one referenced number associated with it and more than one reference number in a single cell. I need to return the ticket # value based on the referenced document.

I have included a sample file.
On Tab- M12-Pend-Closed Late
The reference doc # will be entered in Column G
The value I need returned (the ticket #) should populate in Column O. The value comes from sheet NetforTracking Column I

The Tab- NetforTracking- has all the data points.
Column E- are the reference #'s. Multiple reference #'s could be embedded into 1 single cell.
Column I- is the value I am seeking to return on Tab M12- Column O

Thank you for any help that can be provide.
 

Attachments

NARAYANK991

Excel Ninja
Hi ,

Try this in O2 and copy down.

=IF(G2 = "", "", INDEX('Netfor Tracking'!$I$2:$I$3,MATCH("*" & 'M12 Pend-Closed Late'!G2 & "*",'Netfor Tracking'!$E$2:$E$3,0)))

Narayan
 
Top