Hi,
I have two sets of data, The numbers i want to find in the range might look like:
(Col C)
145
145
145
145
146
146
147
And from these i need it to match against the following examples:
The numbers Before the underscore in cell F will change to all sorts of number/text, however, the numbers after the underscore will always be numbers, and will always have a match in in column C.
What i need is a formula that will identify (for example) 145 is found after the _ in "600_145", and display the who cell in column X.
The Formula goes on Sheet 4, Which has the list i want to match in Column C.
I need the formula to look/match the value in Column C in the below lists (Found on sheet 3) and return the Cell from Col:F.
COL:E COL:F
(Val-Z) (Val-Y_Val-Z)
145 600_145
146 12345_146
152 23456_152
153 34567_153
154 45678_154
155 54789_155
I have tried a bunch of stuff and keep coming back to:
=IF(MATCH('Sheet 4'!C2,'Sheet 3'!E:E,0),'Sheet 3'!F2,""),
And the problem that gives me is that i haven't told excel that COL:E and COL:F are related like that, so it is basically just reproducing the COL:F list.
I think: :frusty: Sums up where im at.
Please help!
I have two sets of data, The numbers i want to find in the range might look like:
(Col C)
145
145
145
145
146
146
147
And from these i need it to match against the following examples:
(Col F) 600_145 |
12345_146 |
23456_152 |
34567_153 |
45678_154 |
54789_155 |
The numbers Before the underscore in cell F will change to all sorts of number/text, however, the numbers after the underscore will always be numbers, and will always have a match in in column C.
What i need is a formula that will identify (for example) 145 is found after the _ in "600_145", and display the who cell in column X.
The Formula goes on Sheet 4, Which has the list i want to match in Column C.
I need the formula to look/match the value in Column C in the below lists (Found on sheet 3) and return the Cell from Col:F.
COL:E COL:F
(Val-Z) (Val-Y_Val-Z)
145 600_145
146 12345_146
152 23456_152
153 34567_153
154 45678_154
155 54789_155
I have tried a bunch of stuff and keep coming back to:
=IF(MATCH('Sheet 4'!C2,'Sheet 3'!E:E,0),'Sheet 3'!F2,""),
And the problem that gives me is that i haven't told excel that COL:E and COL:F are related like that, so it is basically just reproducing the COL:F list.
I think: :frusty: Sums up where im at.
Please help!