I need some help. What i am trying to do is create a formula in which a can
take data that is entered somewhere on a table and return specific values.
for example
8 10 12 14
2X4 SPF 1470
WES
SYP 2090 1400
2X6 SPF
WES 100
SYP
what i need the formula to do is to look through the table which has lengths
across the top. find where a value has been entered, for example the 1470,
and return a value of 2X4X10 SPF. so i am trying to conatenate the 2X4, the
10 and the spf. so my result from this table would equal in order.
2X4X10 SPF
2X4X8 SYP
2X4X14 SYP
2X6X12 WES.
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200612/1