Index And Match [SOLVED]

[MikeLanglois]

Good day all,


I am trying to use Index and match to achieve a kind of reverse v look up. What I need is to pull out what information is in column A on sheet 1, if what is on sheet 2 column C is found. So it looks through Sheet 1 Column C to find what is in Sheet 2 C1, then makes Sheet 2 A1 match what Sheet 1 Column A. For example:


Sheet 1

[pre]

A      B      C
Car 10/06/2013 Ad
Dog 10/06/2013 Ad
Cat 10/06/2013 MS

[/pre]
I want to find out what A1 is, so I put Ad in Sheet 2 C1, and Sheet 2 A1 would become Car.


Does that make sense?


Many thanks,

Mike

 

[DaveTurton]

Use this in A1 on Sheet 2


=INDEX(Sheet1!A:A,MATCH(C1,Sheet1!C:C,0),0)

 

[MikeLanglois]

Thats perfect thank you. I tried along those lines, but there must have been a part of the formulae I was getting wrong so it wasn't working, or bringing back wrong results.


This is perfect thanks very much.