sos question in excel

Copper Contributor

COULD ANYONE HELP ME???

3 Replies
Hi, What is your question?

@emmapapa2 

=VLOOKUP(H1,D2:E13,2,FALSE)

=INDEX(D2:E13,MATCH(H1,D2:D13,0),2)

 

Is this what you are looking for?

If you work with Office365 or 2021 you can use XLOOKUP as well.

@emmapapa2 

Please stop asking every question multiple times!