I have the following in worksheet 1
Whereas in worksheet 2, I have the following
11-DEOXYCORTISOL, LC/MS/MS, SERUM [30543X]
I'd like to do the following:
Condition: Exclude any 'X' at the end of cell B2 from the 2nd sheet and if the value (i.e.30543) is similar to Cell B2 from the 1st Sheet.
then result: Display value of Cell A2 from the 2nd worksheet (S51410) in Cell E2 of the 1st Sheet
I am about to bang my head on the wall with this. Any help is highly appreciated. Thanks