Forum Discussion
Looking Up Value from Another Table and Searching Column
Hi SopandaT,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale
the problem I had with LOOKUPVALUE function is that I could not reference to a column in a table under search value. I wanted to look up the same value in another table in one column and return the result of another column in that another table. Not sure how I could do it.
jennympho- Can you explain that again with maybe an example?
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
