tell me about formulas and functions

Regular Visitor

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.

0 Replies