CODEWITHSUNDEEP
google-sheetsgoogle-sheets-formula
markens
markens

Reputation: 113

Return the value from a range that matches with another cell

I have something like this:

enter image description here

From A8:A10 I have a list with few companies; maybe more, maybe less, perhaps different from the ones in A2:A4. How can I get in B8 the value from C if there is a company in A2:A4 called the same as A8?

Upvotes: 0

Views: 600

Answers (1)

Marios
Marios

Reputation: 27348

What about a simple VLOOKUP:

=VLOOKUP(A8,$A$2:$B$4,2)

enter image description here

or if you want the value in C:

=VLOOKUP(A8,$A$2:$C$4,3)

enter image description here

Upvotes: 3

Related Questions