Ok so i have asked this before in the thread entitled "Transfering Multple Data from seperate worksheet without duplicating" but i did not get a single response.
So i have simplified the question a bit in the hope that i can expand on any response i get.
As you can see i am looking for information in column d (Letter) and getting the result to show from column B (number) using the formula in Column G (result 1).
The problem i am having is that if i try to copy or drag the formula down into Result 2 i just get the same answer.
Is ther any way for the next cell down to ignore the previous result?
Bookmarks