Lookup 2nd value from range

[Vipin Vijayan]

Hi,

How to find the second value from a particular range through vlookup function????

 

[oldchippy]

Hi Vipin,

You could take a look here

http://chandoo.org/wp/2010/11/01/vlookup-excel-formula/

http://chandoo.org/wp/2010/11/02/how-to-lookup-values-to-left/

Or if you have some spare cash

http://chandoo.org/wp/resources/the-vlookup-book/ - that would make Chandoo happy

 

[Vipin Vijayan]

Hi Vipin,

You could take a look here

http://chandoo.org/wp/2010/11/01/vlookup-excel-formula/

http://chandoo.org/wp/2010/11/02/how-to-lookup-values-to-left/

Or if you have some spare cash

http://chandoo.org/wp/resources/the-vlookup-book/ - that would make Chandoo happy

Hi

I will show you an example.

Can you please look into the table below.

Name Qty
Apple 25
Orange 15
Grape 20
Apple 35

What i meant that i need to get the value of "Apple".

 

[Villalobos]

Hi Vipin Vijayan,

D2 = Apple

and try this non-case sensitive array formulae in E2:

 =INDEX($B$2:$B$5,SMALL(IF($D$2=$A$2:$A$5,ROW($A$2:$A$5)-ROW($A$2)+1),2))

with CTRL+SHIFT+ENTER