This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Using LOOKUP in a formula on a different table to ...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

0
329
9

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 06, 2023 09:21 AM

Hello!

I cannot figure this out.

On one table, I have a table that lists the weights of a package on each row, and the cost to ship.

For example, a 1# pkg costs $12.00 to ship, and on the next row, a 2# pkg costs $12.90 to ship.

On a second table, I want to have a formula that takes an item's weight x qty, and __ display the cost to ship __.

So the formula would be

[item wt] x [qty] = [total weight] and then display the cost to ship that TOTAL WEIGHT, and then lookup the cost to ship that weight in my first table.

so if I had a 1 lb item and I have a qty of 2, the LOOKUP would lookup in my first table that it would cost [$12.90] to ship this 2# order, which I would then use in a formula to calculate the total cost of the entire order (item cost )x(qty)+(ship cost).

I cannot figure out how to LOOKUP the SHIP COST ($12.90 in this example) and use it in a formula. Any help very much welcome!

Thank you, Lawrence

9 Replies 9

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 07, 2023 10:20 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 08, 2023 09:43 AM - edited May 08, 2023 09:43 AM

Thank you for looking into this.

OK, so the first table, attached screenshot, is a table of costs to ship various weights via UPS.

I want to use the correct value on a second table. So if the second table calculates a package that is, say, 10 lbs, I want it to lookup the shipping cost of a 10 lb package, and bring to the second table the cost to ship it, which I would then use in a formula.

Try as I might, I have been unable to do this.

Thank you for your help!

Lawrence

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 08, 2023 09:38 PM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 11, 2023 12:29 PM

Yes. They are linked. I'm new to AT.

I want to pull data from one table to the other, but the data is, "For the 10# box, pull the UPS Rate to ship a 10# box. Table 1 has Weight and UPS Rate, and table 2 is where I want to use that data in a formula.

In Excel, it would be "VLOOKUP" to table 1, and put result in formula. But here? I'm at a loss.

But yes, I did link both together.Thank you!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 11, 2023 08:58 PM

Interesting, it should work just fine then

Could you provide access to an example base so that I could assist further please?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 12, 2023 08:50 AM

Thank you SO MUCH.

Here are my UPS Rates: https://airtable.com/shrDZwlHdv9UFXurQ

And here is the table I'm trying to poplulate with the correct weight. But I can't figure out how to lookup the correct weight bases on this table.

https://airtable.com/shrurZzpROg8gzvn3

Thank you, Lawrence

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 13, 2023 05:06 AM

Could you provide an invite link for that example base please?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 22, 2023 07:38 PM

Thank you. Just figured out how to do that! Here you are. Thank you SO MUCH!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 23, 2023 05:01 AM

Thanks!

You already set up everything pretty perfectly actually. Just need to copy and paste the value from "Total Weight" into the "UPS Freight Rates" linked field so that it'll display the correct lookup value:

To automate it, you can make an automation that'll trigger when the "Total Weight" field is not empty AND the "UPS Freight Rates" field is empty, and give it an "Update Record" action to paste the "Total Weight" value in for you, and I've created that automation in the base below for you to check out!