Paying Excel Help - Topic

☰

Member

Posts: 17,661

Joined: Apr 19 2009

Gold: 119.26

Aug 18 2015 02:07am

If in excel you have an example like

Code

a b
1. Car Price
2. Mazda
3.
4. Car Price
5. Ford 100
6. Mazda 150
7. Subaru 200

How do I make it so that when the mazda is typed in A2, in B2 the price is automatically looked up? I've tried so many different ways and can't get it. I can't find my text book and google is not helping.

Eros

Member

Posts: 21,307

Joined: Sep 28 2005

Gold: 0.00

Aug 18 2015 02:20am

at work, but I think I used this to do something along those lines.

http://www.exceltactics.com/vlookup-multiple-criteria-using-index-match/

JukeBOXX

Member

Posts: 17,661

Joined: Apr 19 2009

Gold: 119.26

Aug 18 2015 09:43am

Quote (Eros @ Aug 18 2015 04:20pm)

at work, but I think I used this to do something along those lines.

http://www.exceltactics.com/vlookup-multiple-criteria-using-index-match/

Thanks I was using wrong column number, nowhere explained what that number was except that link. Ty. Sending.

Mikucon

Member

Posts: 26,379

Joined: Feb 24 2011

Gold: 69.69

Aug 18 2015 09:44am

np m8

Eros

Member

Posts: 21,307

Joined: Sep 28 2005

Gold: 0.00

Aug 18 2015 01:05pm

Quote (JukeBOXX @ Aug 18 2015 10:43am)

Thanks I was using wrong column number, nowhere explained what that number was except that link. Ty. Sending.

np. thanks

Hooo

Member

Posts: 6,007

Joined: Jul 22 2010

Gold: 337.21

Aug 19 2015 12:21am

i bookmarked this

this is so awesome!

Go Back To General Archive Topic List

Add Reply New Topic