vlookup query - 2 parameter check....
 

At the moment I have a vlookup query based on one parameter

Ie:

=vlookup(B4, 'pricesA1:H10', 2)

So looks at B4 on current spreadsheet and then goes to the prices page and
withint he range takes the relevant data from column 2.

Thats all well and good.

What I REALLY need to do is for it to look at two paramaeters ie B4 and K4
and match it within a grid - ie postage location AND choice of postage. From
that it can then pick the appropriate price

So a 7 posted at 2nd, would pick the price form the top left cell
2nd 1st recorder eurair etc
7 price price price price
12 price price price etc
cd etc
lp
etc

vlookup query - 2 parameter check....
 

Basically you use Match inside an Index expression
See, for example:
http://j-walk.com/ss//excel/usertips/tip020.htm

A Google with : excel two way lookup : yields nearly 2 million hits.
Have a go and come back if you need assistance
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"David Cumming" <David wrote in message
...
At the moment I have a vlookup query based on one parameter

Ie:

=vlookup(B4, 'pricesA1:H10', 2)

So looks at B4 on current spreadsheet and then goes to the prices page and
withint he range takes the relevant data from column 2.

That's all well and good.

What I REALLY need to do is for it to look at two paramaeters ie B4 and K4
and match it within a grid - ie postage location AND choice of postage.
From
that it can then pick the appropriate price

So a 7 posted at 2nd, would pick the price form the top left cell
2nd 1st recorder eurair etc
7 price price price price
12 price price price etc
cd etc
lp
etc