Index and Match Help

[LaurenL]

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.

 

[NARAYANK991]

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

 

[LaurenL]

Thank you so much!