Function
The function VLOOKUP(), HLOOKUP() and Match() are
designed for this.
Please define yuor question a little more clearly.
Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
THis is a snippet of a function:
Function MassPurlin(b, d) 'Looking up the mass of
purlin,
in relation to b=width, d=depth in Sheet1
Is there someway I could find out the position/location
of
the cell where b or d is stored? Ie, if b is stoed in
cell
B2,
a=worksheets("Sheet1").Cell(b)._____ where a would = 4
.
|