Say I have two datasets loaded in Matlab. The two datasets are shown below together with the desired output (Excel screenshot is for illustration purposes only):
Let's say the first one is A.
A =
Then B should serve as the lookup table:
How do I change the values in A to the values from data B column 1 provided that the data A is equal to the data in B column 2?
Sample output should look like this:
A (values are replaced with values from B column 1) =
Best Answer