Lookup Function question

[CodyMonster]

This works as I would expect it starts looking from the bottom up:
=LOOKUP(2,1/('RiskConcentration Data'!A3:A44<>""),'RiskConcentration Data'!A3:A44)

But as soon as i try to add the address reference the lookup starts looking from the top down.
=LOOKUP(2,1/("'RiskConcentration Data'!A3:"&ADDRESS(MATCH(K4,'RiskConcentration Data'!E:E,0),1,4,1)<>""),'RiskConcentration Data'!A3:A44)

I need to find the first non blank cell in row A but this will change depending on the value.
In K4 in another sheet matches with a number in column 3 in the table below.
For example the number is 456. I'm trying to return "A" in column 1
If K4 = 890 it would return "B" in column 1

A
	ABC	123
	DFG	456
	HIJ	678
B
	LMN	789
	OPQ	890

<tbody>
</tbody>

Thanks for anyone's help. I've been trying to do this myself.
No luck.

 

[jorismoerings]

Hi,

take a look at this:

Excel 2016 (Windows) 64 bit
	A	B	C	D	E	F	G	H	I	J	K
1	A
2		ABC			123
3		DFG			456
4		HIJ			678						678
5	B										A
6		LMN			789
7		OPQ			890
Sheet2

Cell Formulas
Range	Formula
K5	=LOOKUP("zzzzzzz",INDIRECT("a1:"&(ADDRESS(MATCH(K4,E:E,0),1,1,1))))

 

[CodyMonster]

Awesome... !!!!
Worked! Do you know how long I was banging my head against the wall to figure this out?
How does the "zzzzzzz" fall into this?

 

[jorismoerings]

Hi,

The LOOKUP function will apply the lookup_value to the lookup mehtod. One of the elements is if LOOKUP can't find the value of lookup_value, it uses the largest value in the array that is less than or equal to lookup_value. With the creation of an array from the adressed cell upwards, this array will only contain empty cells and 1 cell with a TEXT value (in this case ({"A","","",""}. Instruct lookup to search for a virtual TEXT value which has the largest possible textvalue related to the values in the array (in this case being "zzzzzz") it will return with the largest value that is less than or equal, in this case A.