SOLVED

Can a LookUp Value in Vlookup be a condition?

Occasional Contributor

Can a LookUp Value in Vlookup be a condition?

Hi,

Can a Lookup Value in Vlookup be a condition ?

Something to the effect of

=VLOOKUP(">0.1",D21:F109,3,TRUE)

What i am trying to achieve:

1. Find the first cell in Column D which has value greater than 4

2. Report corresponding cell value from Column A.

Any Ideas.

Thanks

3 Replies

Re: Can a LookUp Value in Vlookup be a condition?

=INDEX(A1:A100,MIN(IF(D1:D100>4,ROW(D1:D100))))

Modify the ranges as needed. If you don't have Microsoft 365 or Office 2021, confirm the formula with Ctrl+Shift+Enter.

Re: Can a LookUp Value in Vlookup be a condition?

Hello,

I tried the formula and got some errors. Any idea what could be wrong ?

The answer for first table should have been 0.3 but i got 0.4. The second one did not give a result. I have tried Ctrl+Shift+Enter as well

Thanks

best response confirmed by AShah16 (Occasional Contributor)
Solution

Re: Can a LookUp Value in Vlookup be a condition?

This is because your ranges don't begin in row 1. In F2:

=INDEX(A3:A13,MIN(IF(D3:D13>4,ROW(D3:D13)-ROW(D3)+1)))

and in F17:

=INDEX(A17:A27,MIN(IF(D17:D27>4,ROW(D17:D27)-ROW(D17)+1)))