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 "example1", the value of F3, as if E3 and F3 are paired. Additionally, would such a solution also work for the other examples B4:B6 and displaying their equivalent in C4:C6? Also if there was a larger amount of data would it still work?

I tried searching for a solution, but couldn't seem to find one, so any help would be great, thanks in advance.

 

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)

     

     

2 Replies

  • 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)

     

     

Resources