Hello, I hope that some1 can help me. I have a spreadsheet which looksup a
list in another sheet of the same workbook based on what account number is
entered in a particular cell. For example,
Sheet1
A B C D
1 Customer Destnation Rate Value
2 R0335 =vlookup..
3
4


Sheet2
A B C D
1 Customer Destination
2 A0022 Ireland
3 D1034 Scotland
4 R0335 Ireland
5 A0022 Wales
6 R0335 France
7 C0078 Spain
8 R0335 Germany

Basically, when I enter the a/c number R0335 I need cell B2 on sheet1 to
list the destinations that R0335 go to, so the operator can list the one that
is required and then cell C2 will look up the rate on B2 using the vlookup
function.

Any help would be gratefully appreciated as this is proving very hard for me
to keep calculating manually as there are about 250 per day.

Thanking you all in advance

Niall