Hello!
I have a problem with formula. I Have two tables. Main and support. Support looks like t
<tbody>
</tbody>
Main looks like this
<tbody>
</tbody>
in my main table, in column "C" I will paste some filenames. I want to fill columns A and B automatically base on column C. First part of a file has the same name as Symbol in support table. I like excel to search if any of the symbol strings match my file and if so, copy FullName to column B of main table. Than I need to check full name with Crit column and copy adequate crit to main column.
My formula so far for FullName column of main table:
=if(D2<>"",
LOOKUP(1E+100,
FIND('SUPPOERT TABLE'!$A$2:$A$119,D2),
'SUPPORT TABLE'!$C$2:$C$119),"")
and it is 99% accurate. - that is not acceptable. This formula has problem with "oper_nand_ODK_" and "oper_nand_" as I can tell but I havent check all 120 possibilities.
Please help.
Best Regards
W.
I have a problem with formula. I Have two tables. Main and support. Support looks like t
Symbol | Crit | FullName |
One_Some_dn_1_ | mas | SOME NAME 1 |
One_Some_dn_11_ | mid | SOME NAME 2 |
Lik_mo_ | mid | SOME NAME 3 |
oper_nand_ | mid | SOME NAME 4 |
oper_nand_ODK_ | mas | SOME NAME 5 |
One_Some_dn_ | app | SOME NAME 6 |
etc | etc | etc |
<tbody>
</tbody>
Main looks like this
Crit | FullName | FILE TO GET |
mass | SOME NAME 5 | oper_nand_ODK_2017_Eng_stig |
mass | SOME NAME 5 | oper_nand_ODK_2018_nna |
mid | SOME NAME 3 | Lik_mo_donar_rettin |
mid | SOME NAME 4 | oper_nand_LOKONTray |
<tbody>
</tbody>
in my main table, in column "C" I will paste some filenames. I want to fill columns A and B automatically base on column C. First part of a file has the same name as Symbol in support table. I like excel to search if any of the symbol strings match my file and if so, copy FullName to column B of main table. Than I need to check full name with Crit column and copy adequate crit to main column.
My formula so far for FullName column of main table:
=if(D2<>"",
LOOKUP(1E+100,
FIND('SUPPOERT TABLE'!$A$2:$A$119,D2),
'SUPPORT TABLE'!$C$2:$C$119),"")
and it is 99% accurate. - that is not acceptable. This formula has problem with "oper_nand_ODK_" and "oper_nand_" as I can tell but I havent check all 120 possibilities.
Please help.
Best Regards
W.