Can anybody please help me.
I have got two worksheets in a workbook. Data from one worksheet is linked to the other. I need to be able to sort the data on the source sheet, but the linked data on the destination sheet must stay where it is.
Unfortunatly when I sort the data on the source sheet the linked data on the destination sheet also moves.
I have attached the two sheets.
Thanks.
Insert the following formula in cell O9 of your destination sheet:
=if(iserror(vlookup(C9;'Source Sheet'!$C$8:$N$20;12;FALSE));0;Vlookup(C9;'Source Sheet'!$C$8:$N$20;12;FALSE))
You can drag down to all cells bellow.
The only possible issue with this one is if you misspel the name of species in the source will show up as blank in the main one. (due to the Iserror statement in this formula)
One possible solution is to have in the formula "True" instead of "False"
False at the end will only return exact matches of the data, True will give you the closest match (according to excel rules)
--------------------------------------------------------------------------------
Last edited by Portuga; 03-12-2008 at 08:55 PM.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
Well done Portuga,
The formula works a treat. There can't be any problems with mis-spelling species names as I copied from one list to the other.
Thanks again I've been struggling with this one for days.
Peter.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks