View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Cazulu Cazulu is offline
external usenet poster
 
Posts: 2
Default 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