Jason

Hello - I am trying to do a VLookup for a large range of cells to be linked to another file. I can not seem to come up with a good solution. I currently have 15 tabs in one file and would like to creat a look up function wo when ever a new client comes abloard, I can simple revert back to the lookup file.

The formula you see is not working, is there anyone who can help or give a tip about doing a lookup for a file for the ranges for example $A$1:$EB$148)=+VLOOKUP(ITS - Proforma Financial Statements - $1 mil cash target, $A$1:$EB$148)

thanks - Jason