Lookup formula - variable value

[nassr]

I am working with lookup formulas, but I need to know if it is possible to run a hlookup where the lookup_value is a variable (i.e. >0)? Is this possible, if not any ideas on what I could do to get it to work? thanks!

 

[Oaktree]

Sure.

=HLOOKUP(A1,B1:G20,5,0)

Where A1 stores your lookup_value.

 

[barry houdini]

If I understand correctly.....

=INDEX(A2:Z2,MATCH(TRUE,A1:Z1>0,0))

confirmed with CTRL+SHIFT+ENTER

will give you the corresponding value in row 2 for the first value in row 1 greater than 0

 

[Oaktree]

Ah, that makes more sense, Barry.

If the OP wants to stick with HLOOKUPs, s/he could try =HLOOKUP(2.229E-308,A1:Z2,2)

 

[nassr]

Thanks alot, Works great!

I ended up using the Index formula but need to flip the rows that it was looking in (Row 2 returns a row 1 value).