Hi Cameron

How about something like this:

=VLOOKUP(Sheet1!A2,Sheet2!$A$2:$D$1000,MATCH(Sheet 1!B2,Sheet2!$B$1:$D$1,0),0)

Ranges will need adjusting to suit.

Best regards

Richard


--
RichardSchollar
------------------------------------------------------------------------
RichardSchollar's Profile: http://www.excelforum.com/member.php...o&userid=34698
View this thread: http://www.excelforum.com/showthread...hreadid=547135