I am not sure what you want, but here i am giving some solution according to
my understanting:
=IF(ISERROR(VLOOKUP(B3,sheet2!$A$1:$IK$400,MATCH(D 3,sheet2!$A$1:$IK$1,0),FALSE),VLOOKUP(B3,sheet3!$A $1:$IK$400,MATCH(D3,sheet2!$A$1:$IK$1,0),FALSE),VL OOKUP(B3,sheet2!$A$1:$IK$400,MATCH(D3,sheet2!$A$1: $IK$1,0),FALSE))

If you are not satisfied, pls do mail to with your
workbook.



"phil2006" wrote:


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

It's not entirely what I meant. My problem is that I have a distance
chart with more places along the top row than there are columns. Thus
the distance chart must be over two sheets. Whn I type two places into
the original sheet the distance is read using the above formula. I now
need to edit the fromula so that it can read data from both distance
sheets.

Thanks


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