Forum Discussion

wanalearn's avatar
wanalearn
Brass Contributor
Aug 21, 2022
Solved

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...
excel
Formulas and Functions
  • Harun24HR's avatar
    Harun24HR
    Aug 21, 2022

    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's avatar
Harun24HR
Bronze Contributor
Aug 21, 2022

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)
  • wanalearn's avatar
    wanalearn
    Brass Contributor
    Aug 21, 2022
    Harun24HR Great, it's in use already

Resources