Looking Up Value from Another Table and Searching Column

Greg_Deckler

Hi Greg,

this is how I have resolved the problem at the end but i wonder if there's a quicker method.

I have 2 tables.

Table 1 - has 2 columns - account number and amount

Table 2 - has 2 columns - account number and whether overhead cost applies to that account number

I wanted to create a formula that will add the overhead cost to the amount if it should.

So, now this is how I have figured out to solve the issue:

1.  I added a calcuated column and use a LOOKUPVALUE function in table 1 to see if overhead cost should apply

2.  I added another calculated column to calcuate the overhead cost (amount x overhead rate) if overhead cost should apply

I wonder if this can be done in 1 formula and in 1 calculated column.

thanks for sharing your knowledge in advance!
Jenny