find and display

[westie1871]

Hi Guys,

i am looking for a little bit of advice i have an excel spreadsheet that displays a row of postcodes and then a itm QTY at the top and a price i am looking for a solution that would allow me input a postcode and a qty and it returns the value

what is the best way to do this? if you could give me some points i would be very greatful

thanks in advance

 

[SkipVought]

hi,

Please post an example of your data.

It is not clear that data is where.

Please ALSO describe what row/column the data is in that you post as an example.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}