I have the following in worksheet 1
Cell B2
30543
Whereas in worksheet 2, I have the following
Cell A2
S51410
Cell B2
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
Bookmarks