SOLVED

# formulas and functions

Brass Contributor

# formulas and functions

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

# Re: formulas and functions

@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)``

# Re: formulas and functions

@Harun24HR Great, it's in use already
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

# Re: formulas and functions

@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)``