Index Match - nested If (less than/greater than statements)

**kelea** · 08-28-2009, 02:58 PM

Hi,

Thanks for the response but i'm confused to the "1/" that is on the equation. i also filled in more details.

Thanks

**DonkeyOte** · 08-28-2009, 03:01 PM

In which case, modified version below

E3: =LOOKUP(2,1/(($A$1:$A$6=$E$1)*($B$1:$B$6<=$E$2)),$D$1:$D$6)

**kelea** · 08-28-2009, 03:07 PM

It's still not working

i'm sorry to be so difficult!

Could you explain what is the purpose of the 2 and 1/ in the front of the equation please?

Thanks!

**DonkeyOte** · 08-28-2009, 03:08 PM

Post a file in which you have your table and the formula present.

Re: explanations - I would suggest getting it to work in the first instance.

**kelea** · 08-28-2009, 04:03 PM

ok the inputs are on the tab 'Sheet1' and the references are on 'employee range'

i need the formula to work in 'Cat employees'

thanks

**DonkeyOte** · 08-28-2009, 04:07 PM

You're getting an error because there are no values in Column C for Germany < 5 (value in D2) thus no value can be returned from D given no rows meet all criteria.

Index Match - nested If (less than/greater than statements)

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Index Match - nested If (less than/greater than statements)

Re: Index Match - nested If (less than/greater than statements)

Re: Index Match - nested If (less than/greater than statements)

Re: Index Match - nested If (less than/greater than statements)

Re: Index Match - nested If (less than/greater than statements)

Re: Index Match - nested If (less than/greater than statements)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions