Forum Discussion

Squalkl's avatar
Squalkl
Copper Contributor
Mar 18, 2023
Solved

How to display an item from a paired group of information when a cell has a value

I have no idea how to word this, and I am a complete newcomer to this, but say I have this data in E3:E6 and F3:F6. If I entered 100 in B3, like in this image, how would I get C3 to display "example...
excel
  • Harun24HR's avatar
    Harun24HR
    Mar 18, 2023

    Squalkl You need XLOOKUP() function.

    =XLOOKUP(B3:B6,E3:E6,F3:F6)

    If you are on old version of excel then use VLOOKUP().

    =VLOOKUP(B3,$E$3:$F$6,2)

     

     

Harun24HR's avatar
Harun24HR
Bronze Contributor
Mar 18, 2023

Squalkl You need XLOOKUP() function.

=XLOOKUP(B3:B6,E3:E6,F3:F6)

If you are on old version of excel then use VLOOKUP().

=VLOOKUP(B3,$E$3:$F$6,2)

 

 

Squalkl's avatar
Squalkl
Copper Contributor
Mar 18, 2023
Thankyou so much

Resources