If statement to grab only first occurance from multiple columns and put in single column

[wallace23]

Hello All,

I have part numbers that are scattered through my spreadsheet. i.e. I have part numbers in cells F3 to J3. i need help with an IF statement that will take the first occurance in place it in A3.

For example, I have a part number in F3 and that is it that is fine. However I have a part number in G4 and H4 and I want the formula to only take the first part number and place it in A4.

This is the formula I have in A3:
=IF(F3="",G3&H3&I3&J3,F3), this works however if there is a part number in G3 & H3 then it takes both part numbers and combines it in A3.

Thanks,

Wallace23

 

[sheetspread]

Tom Urtis posted this formula a few years ago, it works pretty well:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
3	482					482	7
4	62							62	709
5	91						91
6	310					310
7	415									415
8	990								990	588
Sheet1

 

[wallace23]

Thanks sheetspread! That's exactly what I was looking for.

regards,

Wallace23