Vlookup with more than single Column Index

**sumonrezadu** · 01-22-2010, 11:37 AM

Can Vlookup use multiple column index. How can I solve my problem depicted in attached file? Is there any solution?

**ChemistB** · 01-22-2010, 12:10 PM

There's probably a more elegant way but I extended your lookup table out to column I with H and I having alternate potential names for your vehicles and then your formula becomes (dragged down)

Please Login or Register  to view this content.

Hopefully you don't have more than 3 synonyms for each car/truck. Note, this formula can be shortened if you are using Excel 2007.

**martindwilson** · 01-22-2010, 12:12 PM

i dont think you need the v look up just use a countif with wildcard for each
=COUNTIF($B$28:$B$60,"*207 di*")
=COUNTIF($B$28:$B$60,"*lp 407*")

**DonkeyOte** · 01-22-2010, 12:12 PM

Using your sample file, one approach might be:

Please Login or Register  to view this content.

adjust ranges to suit.

**sumonrezadu** · 01-22-2010, 01:13 PM

Thanks a lot for the quick solve.

**sumonrezadu** · 01-23-2010, 08:22 AM

Thanks a lot for your reply

**teylyn** · 01-23-2010, 08:32 AM

sumonrezadu, could you please take a moment and update your profile with your Office version. Some solutions will be different depending on what version you are using and we want to make sure to provide the best solution for you the first time when you ask your next question.

cheers.