My data sheet is too large to fit on one sheet as there are not enough
columns. Is it possbile to have a formula that reads from both sheets?
The formula that has been working for one sheet is:

=((VLOOKUP(B3,sheet2!$A$1:$IK$400,MATCH(D3,sheet2! $A$1:$IK$1,0),FALSE))


Any help would be great!!

Thanks


--
phil2006
------------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...o&userid=35092
View this thread: http://www.excelforum.com/showthread...hreadid=562811