# Functions in Excel

Discussion in 'Business Applications' started by cleo123, May 28, 2010.

Not open for further replies.

Joined:
May 28, 2010
Messages:
1
Hi. can someone help me simplify this formula?

=IF(OR(NOT(\$L4=""),NOT(\$N4="")),HLOOKUP(\$H4&"-2",raw_Test1.1!\$C\$2:\$EE\$364,MATCH(\$D4,raw_Test1.1!\$B\$2:\$B\$399,0),0),"")

2. ### Jimmy the Hand

Joined:
Jul 28, 2006
Messages:
1,223
This seems pretty much the simplest solution. I can think of only two additions.

1)
You could define some named ranges, like
SearchTable = raw_Test1.1!\$C\$2:\$EE\$364

2)
contract the OR like this
\$L4 & \$N4 <> ""

Result:
=IF(\$L4 & \$N4 <> "",HLOOKUP(\$H4&"-2",SearchTable,MATCH(\$D4,HeaderRow ,0),0),"")

This formula isn't simpler or faster, but maybe it's easier to read.

Jimmy

3. ### slurpee55

Joined:
Oct 20, 2004
Messages:
7,837
Cleo, welcome to the forum! However, when you have a problem, start your own thread. Jimmy was nice and answered your question (although I would leave your formula as it is), but don't piggyback like that onto someone else's thread in the future.

4. ### cybertechRetired Moderator

Joined:
Apr 16, 2002
Messages:
72,116
Hi, Welcome to TSG!

As Seen On