vlookup

[grantholt]

hey guys,

I would use the search function, but for some reason I can't, so here it goes.

I'd like to be able to write a name down in sheet 2a1 and in b1 it has the number corresponding to it enter into it by looking it up in sheet 1.

For example, if on sheet 1 cell a5 I have Tesco, and in b5 £101 I want in sheet 2 b1 £101 after I have written Tesco into a1.

I hope you understand me.

 

[Robert Mika]

VLOOKUP should help

http://www.mrexcel.com/tip096.shtml

 

[Sal Paradise]

hey guys,

I would use the search function, but for some reason I can't, so here it goes.

I'd like to be able to write a name down in sheet 2a1 and in b1 it has the number corresponding to it enter into it by looking it up in sheet 1.

For example, if on sheet 1 cell a5 I have Tesco, and in b5 £101 I want in sheet 2 b1 £101 after I have written Tesco into a1.

I hope you understand me.

Given this data:

Excel 2003
	A	B
1	Selfridges	32
2	M&S	55
3	Two Tuns	87
4	Pret	235
5	Tesco	101
Sheet1

On sheet 2:

Excel 2003
	A	B
1	Tesco	101
Sheet2

Cell Formulas
Range	Formula
B1	=INDEX(Sheet1!B:B,MATCH(A1,Sheet1!A:A,0),)