jasonseebaluck
New Member
 Joined
 Jul 6, 2020
 Messages
 5
 Office Version

 2019
 Platform

 MacOS
Hello All,
I am a little new to this excel forum thing, am self taught, so apologies in advance. I have had a cursory look at some similar forum queries and am unable to work backwards to fix my problem.
My original problem: find the 2nd shift code in D132 along a list E$82:E$124 and reference shift worker on that shift in column ($L$82:$L$124)
D132 = shift code (which was simply the letter and number "D2")
fixed with the following:
=IFERROR(INDEX($L$82:$L$124,SMALL(IF($D$132=E$82:E$124,ROW(E$82:E$124)ROW(E$82)+1),2)),"Vacant")
My new problem:
My manager now wants the second shift of either D2 or D2X codes to be matched.
So I initially tried to keep the same formula above. However in the shift code reference, I placed "D**" in D132, to pick up either D2 or D2x...however it did not work.
I have read on the forums that I could use IF(ISNUMBER(Search)...but unsure whether this will provide the function I require?
Any help would be gratefully received.
Jason
I am a little new to this excel forum thing, am self taught, so apologies in advance. I have had a cursory look at some similar forum queries and am unable to work backwards to fix my problem.
My original problem: find the 2nd shift code in D132 along a list E$82:E$124 and reference shift worker on that shift in column ($L$82:$L$124)
D132 = shift code (which was simply the letter and number "D2")
fixed with the following:
=IFERROR(INDEX($L$82:$L$124,SMALL(IF($D$132=E$82:E$124,ROW(E$82:E$124)ROW(E$82)+1),2)),"Vacant")
My new problem:
My manager now wants the second shift of either D2 or D2X codes to be matched.
So I initially tried to keep the same formula above. However in the shift code reference, I placed "D**" in D132, to pick up either D2 or D2x...however it did not work.
I have read on the forums that I could use IF(ISNUMBER(Search)...but unsure whether this will provide the function I require?
Any help would be gratefully received.
Jason