Lookup value and return info about the value

miranaskype · Dec 18th 2013

Hi Guys,

im having a problem i cant figure it out how to return the value of what i looking up. for example i want to find the value of A1 from a range of B1:B10 if A1 is B1 then it return the value beside B1 for example the value of B1 is C1 please help guys. many thanks in advance.

etaf · Dec 18th 2013

Re: Lookup value and return info about the value

have you tried vlookup or index /match

vlookup would be

=vlookup(A1,$B$1:$C$10,2,false)

index/match

=index($c$1:$c$10, match(a1,$B$1:$B$10,0))

**royUK** · Dec 18th 2013

Re: Lookup value and return info about the value

Maybe you need INDIRECT

This formula in A1

=OFFSET(INDIRECT(A2),,1)

In A2 type B1 or whichever reference you need

Lookup value and return info about the value

Participate now!

Share