View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Hi Could you please help?

=IF(SUMPRODUCT(--(MID($A$1:$A$59,2,99)=MID(B1,2,99))),B1,"")


"Cazumel" wrote:

Thank you for your help and prompt response, but it doenst work because the
numbers may not repeat itself in a much lower cell
Instance: R0060 is on row number 1 M0060 is on row number 60:

M0002 R0060
M0003 R0096
M0004 R0113
M0001 R133
M0005 R0153
M0006 R0157
M0007 R0279
M0008 R0280
M0009 R0349
M0010 R0359
M0011 R0400
M0012 R0500
M0013 R1225
M0014 R1226
M0015 R1228
M0016 R1229
M0017 R1230
M0018 R1231
M0019 R1232
M0020 R1233
M0021 R1234
M0022 R1235
M0023 R1236
M0024 R1238
M0025 R1239
M0026 R1240
M0027 R1241
M0028 R1242
M0029 R1243
M0030 R1244
M0031 R1245
M0032 R1246
M0033 R1247
M0034 R1248
M0035 R1249
M0036 R1250
M0037 R1251
M0038 R1252
M0039 R1253
M0040 R1254
M0041 R1255
M0042 R1256
M0043 R1257
M0044 R1258
M0045 R1259
M0046 R1260
M0047 R1261
M0048 R1262
M0049 R1263
M0050 R1264
M0051 R1265
M0052 R1266
M0053 R1267
M0054 R1268
M0056 R1269
M0057 R1270
M0058 R1271
M0059 R1272
M0060 R1273




"Cazumel" wrote:

I have the following situation

Column A Column B Column C
M Project# R Project#
M0001 R133
M0002 R0060
M0003 R0096
M0004 R0113
M0005 R0153
M0006 R0157
M0007 R0279
M0008 R0280
How do I build a formula on Column C where each time the digits match (A,B)
to return the value existing on column B?

Ex:
Column A Column B Column C
M0008 = R0008 repeat R0008

Thank you so much in advance for your help.