The "IF' formula

[Kent]

Sounds more like a lookup than an IF() or perhaps even a
dropdown list. Not enough info to give you a clean idea.
With a better picture of this I could be of more help.

Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
-----------
Every member of the CanHelpYou team holds at least a
Microsoft Level 1 Excel certification. In addition, we
have experts in PowerPoint, Word and other products such
as IIS, SQL Server 2000, network connectivity.

-----Original Message-----
I been messing with this too long today Basicly I was

trying to set it up so if I typed in the A4 it would put
the respective matlerial in that cell. But my question is
am I going about this wrong how else could I do this to
get the desired result.

=IF(E10=A4,"A320-L7 XLAN COATED",IF(E10=B4,"A194-4 XYLAN COATED"))

The problem I am running into is using the "=" E10=

All the examples I can find show you putting a E10>B4

then this formula would work. The problem with this is I
need to make this sell work for A4 B4 C4 D4 A5 B5 C5