Need a bit of advice on m vlookup.

I currently have the following formula =(IFERROR(VLOOKUP($A3,'Tracker 2013.xlsx]Open'!$A:$F,2,0),"")) which looks up various data in a different workbook. I need to extend this to look in to more than one worksheet if the data can not be found in "open".

I came up with the following

=(IF(NOT(ISERROR(VLOOKUP($A7,Open!$A:$Z,4,0))),VLOOKUP(Summary!$A7,Open!$A:$Z,4,0)</SPAN> |

,(IF(NOT(ISERROR(VLOOKUP($A7,'On Hold'!$A:$Z,4,0))),VLOOKUP(Summary!$A7,'On Hold'!$A:$Z,4,0)</SPAN> |

,(IF(NOT(ISERROR(VLOOKUP($A12,Pending!$A:$Z,4,0))),VLOOKUP(Summary!$A12,Pending!$A:$Z,4,0),"")))))) and while it worked in my testing spreadsheet its coming up blank when I try to apply it where its needed. Any ideas? Thanks, Suzie </SPAN> |

<TBODY>

</TBODY><COLGROUP><COL></COLGROUP>