I have a master spread sheet - info grouped under various managers who are
responsible. I want to maintain the master spread which then shows on
indiviual tabs grouped by the above managers
playing around with the following formula biut not sure if its the best
thing to be using.
=IF($A2="","",VLOOKUP($A2,ALL_CONTRACTS!$A:$B,2,FALSE))
cheers Pete
Bookmarks