SOLVED

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

Copper Contributor

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.

 

example.PNG

2 Replies
best response confirmed by Squalkl (Copper Contributor)
Solution

@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_0-1679196422663.png

 

1 best response

Accepted Solutions
best response confirmed by Squalkl (Copper Contributor)
Solution

@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_0-1679196422663.png

 

View solution in original post