If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Select" type statement
Hello all
I have a grid of data, with prices for posting parcels in the UK. There are 3 different ways which parcels get sent, 1st Class, 2nd Class or Parcelpost. There is a column for each of these. The first column holds info about the maximum weight per item for these. The rows hold the information about the price of each method of sending. I want to be able to put the weight of a parcel into a cell, and then lookup what is the cheapest price postage for a item weighing that much. Could anyone give me a hand doing this? I've just started with this kind of work and am finding it quite difficult to determine what all the various functions are for. Cheers Richard |
#2
|
|||
|
|||
"Select" type statement
This file might be a help:
http://www.bygsoftware.com/examples/.../xindexvba.zip It's in the "Excel for Lotus 123 Users" section on page: http://www.bygsoftware.com/examples/examples.htm In Excel there is no direct equivalent for Lotus 123's XINDEX function. This workbook shows two Excel formula constructions that achieve the same result. The first example uses two additional inputs. It uses the Excel functions: INDEX and MATCH The second example uses the same inputs as the Lotus XINDEX function. It uses the Excel functions: INDEX, MATCH and OFFSET. There are also two additional pieces of VBA showing how to use this in code and capture an error condition. The code is open and commented. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "The Excel Auditor" and "Byg Tools for VBA" "Richard Davies" wrote in message ... Hello all I have a grid of data, with prices for posting parcels in the UK. There are 3 different ways which parcels get sent, 1st Class, 2nd Class or Parcelpost. There is a column for each of these. The first column holds info about the maximum weight per item for these. The rows hold the information about the price of each method of sending. I want to be able to put the weight of a parcel into a cell, and then lookup what is the cheapest price postage for a item weighing that much. Could anyone give me a hand doing this? I've just started with this kind of work and am finding it quite difficult to determine what all the various functions are for. Cheers Richard |
Thread Tools | |
Display Modes | |
|
|