Lookup formula help

1

Hey guys can anyone point me in the direction of this solution?
Im sure there many threads about this formula already.

Screenshot%20from%202019-11-02%2018-19-47
Screenshot from 2019-11-02 18-19-47.png841×578 27.7 KB

Im trying to multiply the value of column “SF” by the value of the column “Factor” for the row chosen in column “Width/Texture”

Seems simple but I know very little about formulas, excel or otherwise. Thanks!

2

I guess you could try something like this if your field is a Lookup:
(I can test this right now though :confused: )

Product(thisrow.SF,thisrow.Width/Texture.Factor)

Or maybe this

Product(thisrow.SF,Lap.Filter(Width/Texture=thisrow.width/texture.width/texture).factor)

1 Like
3

Thanks! I ended up formatting the “Width/Texture” Column as a lookup and added "factor as a related row and hid it. I don’t want to break it so Ill leave it as is but I will definitely be using these as a reference in the future. I have had the same problem multiple times but keep forgetting how I made it work. Now I can just check back in this thread, Thanks again!

4

That was gonna be my next suggestion :wink: .

Glad to know you made it work :wink: .