Match Multiple Values
Thanks for your help Max and T.V
"Cazulu" wrote:
I have 2 variable values in spreadsheet 1 that match 2 values in spreadsheet
2. The B/MarkCost needs to be reported back to Spreadsheet 1. Any ideas on
how to do it?
Eg.
Spreadsheet 1
To Suburb Serv B/markCost
ALBION E
ALDERL N
ALBION N
Spreadsheet 2
TO SERV B/MarkCOST
ALBION E $37.06
ALDERL N $14.96
ALEXAN E $31.35
A.OVER G $62.70
ALBION N $7.80
ALBION A $78.40
|