"Select" type statement

[Richard Davies]

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

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/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"