Is there any formula for this?
I have 2 sheets, sheet 1: column A codes in column B values, for example, in cell A1 0001 and in Cell B2 0.058 and so on in other rows, I want in sheet 2 when I enter in a cell. the code (3655) it should automatically pop up in the next cell the value (0.058)
so, I understand that i will have to connect the data from columns A and B from sheet 1 and then to sheet 2. How?
Thanks!
Best Regards.
