Index if

[keiserj]

Having trouble with this formula. In column A of Sheet1 i have a list of Log ID which show up either, MFG010318134515 or PURCH010318164059 which the numbers are time stamp and MFG or PURCH will be added via userform. What im trying to do is take all MFG Log ID and past into Sheet2 column a so that i can pull different data off of Log ID.

=IF(LEFT('Sheet1'!$A4,3) = "MFG", 'Sheet1'!$A4,"")

Works but has gaps in where PURCH shows up


Any help would be great!

 

[AhoyNC]

TRY:
This is an array formula that must be entered with CTRL-SHIFT-ENTER.
Drag down column as needed.

Excel Workbook
	A
1	MFG010318134515
2	MFG010318134516
3	MFG010318134517
4	MFG010318134520
Sheet2

Excel Workbook
	A
1
2
3
4	MFG010318134515
5	MFG010318134516
6	MFG010318134517
7	PURCH010318164059
8	PURCH010318164059
9	MFG010318134520
Sheet1

 

[keiserj]

AhoyNc that worked great thank you!. I was really close but was using wrong reference. Thanks again!!

 

[AhoyNC]

You're welcome. Thanks for the feedback.