M
martin
I download a file into excel & have to deal with the fact
that it does not come out in a particular order.
So I have data as:
B1 C1 D1 E1
410 410-xxx data Result
My formula states =IF(LEFT(C1,3)=RIGHT(B1,3),E1,"")
and I get the answer "Result"
However, the download also places info as follows:
B1 C1 D1 E1
A222XXX HF01 Result 6.5
I have done an interim fix which will result in a long
winded route of getting all the "Results" in 1 column but
is there any way of having a single cell formula that will
pick up both "Results" whether they be in column D or E?
I don't think I can use a VLOOKUP as the "Results" in
question are actually dozens of different words.
Good Luck!
that it does not come out in a particular order.
So I have data as:
B1 C1 D1 E1
410 410-xxx data Result
My formula states =IF(LEFT(C1,3)=RIGHT(B1,3),E1,"")
and I get the answer "Result"
However, the download also places info as follows:
B1 C1 D1 E1
A222XXX HF01 Result 6.5
I have done an interim fix which will result in a long
winded route of getting all the "Results" in 1 column but
is there any way of having a single cell formula that will
pick up both "Results" whether they be in column D or E?
I don't think I can use a VLOOKUP as the "Results" in
question are actually dozens of different words.
Good Luck!