
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Feb 27, 2018 04:02 PM
I am trying to use Lookup data in a formula and can’t get it to work.
Table A is a list of print products, and column 1 are the unit costs pulled from linked table B, which contains unit costs for different page counts.
In another column on Table A, I want to multiply the unit cost by 25. I have tried doing this using a forumla, and I have tried it using the Rollup function, and both result in “error.”
Also another weird thing I noticed: If I format the the column in table B that contains the unit costs as a number, the Lookup data in table A gets rounded up to a 1! So I can’t get any meaningful sums when I group the data. The only way to get the correct numbers to show up is if I leave the column in Table B formatted as short text.
Weird!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 21, 2023 05:24 AM
This worked for me!

- « Previous
-
- 1
- 2
- Next »