Lookup formula - variable value

nassr

New Member
Joined
Sep 8, 2006
Messages
11
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!
 

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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
 
Upvote 0
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)
 
Upvote 0
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).
 
Upvote 0

Forum statistics

Threads
1,223,308
Messages
6,171,329
Members
452,396
Latest member
ajl_ahmed

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top