Hi,
This problem can be solved without the use of any code as the inbuilt
VLookup or a combination of the Index & Match functions of Excel will
do the job & may be quicker than the code solution already offered.

Assuming your codes are listed in column A of all the sheets & the
other variable is in column B on each of the sheets, enter the
following into column B of the 3rd sheet and copy it down:
(Adjust the lookup ranges to match the amount of data in the sheets.)

=VLOOKUP(Sheet3!A2,Sheet1!$A$1:$B$2,2,FALSE)*VLOOK UP(Sheet3!A2,Sheet2!$A$1:$B$2,2,FALSE)

Or

=INDEX(Sheet1!$A$1:$B$2,MATCH(Sheet3!A2,Sheet1!$A$ 1:$A$2,0),2)*INDEX(Sheet2!$A$1:$B$2,MATCH(Sheet3!A 2,Sheet2!$A$1:$A$2,0),2)

Once the results have been found I'd copy & paste as values to speed up
your workbook & minimise the file size. I usually keep a copy of the
formula in a comment on the header row in case it is needed again when
values ie the rate or the quantity change.

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=534484