trying to return a value using Xlookup and match from a price table

**iks181** · 04-21-2024, 01:12 PM

Hi Folks,

I'm trying (& failing) to get this formula to work?

I need it to search a price table for a price for a made to measure product.

The product is priced per width and height so the formula needs to round up to the next higher price bracket.

I've got the formula to return the price for the product if i input the sizes exactly as per the size table (Sheet 3) as soon as i change the sizes to something other than the sizes on the price table and try to add the Match function to round up to the next highest size it doesn't like it!

any help or pointers would be very much appreciated.

**mike7952** · 04-21-2024, 01:32 PM

Try this maybe

Formula:

Please Login or Register  to view this content.

**TMS** · 04-21-2024, 01:33 PM

Try:

Formula:

Please Login or Register  to view this content.

**iks181** · 04-22-2024, 04:25 AM

Hi Mike,

Thats got it!

Many thanks

Ivan

**AliGW** · 04-22-2024, 04:26 AM

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

**TMS** · 04-22-2024, 05:11 AM

@iks181: and post #3?

**iks181** · 04-22-2024, 10:05 AM

Hi TMS

Yes that works

Many thanks for the help

Ivan

**TMS** · 04-22-2024, 11:02 AM

You're welcome. Thanks for the rep.

trying to return a value using Xlookup and match from a price table

LinkBack

Thread Tools

Rate This Thread

Display

trying to return a value using Xlookup and match from a price table

Re: trying to return a value using Xlookup and match from a price table

Re: trying to return a value using Xlookup and match from a price table

Re: trying to return a value using Xlookup and match from a price table

Re: trying to return a value using Xlookup and match from a price table

Re: trying to return a value using Xlookup and match from a price table

Re: trying to return a value using Xlookup and match from a price table

Re: trying to return a value using Xlookup and match from a price table

Thread Information

Users Browsing this Thread

Similar Threads

Return an entire table or range of values using XLOOKUP, or another formula function?

[SOLVED] Help with xlookup combined with index match and table references

[SOLVED] Multiple XLOOKUP/INDEX(MATCH) functions to return one value.

[SOLVED] How to return results of a top 5 lowest price, top 5 highest price and price difference?

Compare 2 columns and if they match return a price from a 3rd column

[SOLVED] VLOOKUP match multiple values to return one value + find min price

Many Condition need to match and return a unit price - Urgent assignment

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions