Index match

[shadedlight]

Hello,

I believe this is fairly straight forward but I'm having a difficult time remembering how to do an index match for my problem.

I have a list of different herbs Column A-D

Then in column G I want to enter an herb and have Taste column B, Temperature column C, and Element Column D appear in column H, I, and J

So if I enter 'Baihe' (Located in A2) the information from that row will appear H3, I3, J3.

Thank you in advance as this would help tremendously.

 

[Nebu]

Hi:

Find the attached.


Thanks

 

[rahulshewale1]

hii,

Another Option ,

Cell H2 :
=VLOOKUP(F2,$A$1:$D$126,2,FALSE)

Cell I2 :
=VLOOKUP(G2,$A$1:$D$126,3,FALSE)

Cell J2 :
=VLOOKUP(G2,$A$1:$D$126,4,FALSE)


Regard
Rahul shewale

 

[rahulshewale1]

Hii,

another option,
using name range
Cell H2 Copy across :
=INDIRECT($F9) INDIRECT(G$8)

Pfa sheet.
note
Use space betweet two indirect .
Regard
Rahul shewale