If you can live with #N/A with no match

=MATCH(D1,{"DELL","GATEWAY","HEWLETT"},0)

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"killertofu" wrote
in message ...

Help me simplify this function into something that I never have to write
again... Thanks, ahead of time...

HERE ARE THE CELLS:
A
1 DELL
2 GATEWAY
3 HEWLITT

HERE IS THE FORMULA FOR B1 THAT NEEDS STREAMLINING:
=IF(A1="DELL",1,IF(A1="GATEWAY",2,IF(A1="HEWLITT", 3,"NOTHING")))


--
killertofu
------------------------------------------------------------------------
killertofu's Profile:
http://www.excelforum.com/member.php...o&userid=31024
View this thread: http://www.excelforum.com/showthread...hreadid=512398