SOLVED

formulas and functions

Occasional Contributor

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?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@wanalearn You can use INDEX/MATCH, VLOOKUP(), XLOOKUP(), FILTER() any of these.

=INDEX(Sheet1!B:B,MATCH(B4,Sheet1!A:A,0))

 XLOOKUP like

=XLOOKUP(B4,Sheet1!A:A,Sheet1!B:B)
@Harun24HR Great, it's in use already