Lookup formula

[JV0710]

Hi, Please help me with this lookup query.

I have a column of data in a hierarchy (columnA).

As per the picture posted: if I type the store in cell D3, I want a formula in E3 to return the area that the store belongs in.

Thank you
JVN

Book1
	A	B	C	D	E	F	G	H	I	J
1		%Growth		Store	Area
2	Area1	12
3	store1	10		store6	Area2
4	store2	14
5	store3	12		needaformulainE3thatwillreturntheareathatstore6(F3)belongsin
6	Area2	14
7	store4	10
8	store5	10
9	store6	15
10	store7	16
11	store8	4
12	Area3	9
13	store9	6
14	store10	6
15	store11	12
16	store12	8
Sheet1

 

[Aladin Akyurek]

...In Column A and for example: In cell D7, if the value in A7 = "A", then "", else, if the value in A7 <> "A" then need formula to find in column A from A7 upwards the first cell that has a different letter (A4) and return the corresponding value in column B ----> Answer = 24...

It looks like you meant...

B2, copied down:

=IF(A2="A","",LOOKUP(2,1/($A$1:A1<>A2),$B$1:B1))

 

[JV0710]

Thank you

I cannot tell you the amount that I have learnt just from this post . . .

JVN