Thread: Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
patrick molloy patrick molloy is offline
external usenet poster
 
Posts: 391
Default 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
.