I have two worksheets--both have store numbers listed, but one is just an location list and the other includes call frequencies. I want to pull the call frequencies from the second worksheet onto the first. The store numbers start with column G2 on the location list, and A2 on the call frequencies sheet. The data on the call freq sheet that I want to copy to the location list are columns C,D & E through row 755..
The kicker is that a co-worker helped me with this, and his formula (which worked) was =VLOOKUP($G2,'Call Frequencies'!$A$2:$C$755,2,FALSE)
I continued adding information to the worksheet for several hours after sending it to him, so when I received it back with the formula, the original worksheet had had many changes (data in other columns, not the ones listed above) I tried to transfer the formula to my much more completed worksheet, yet the exact formula that worked on the earlier version now does not work, in spite of the fact that I changed no formatting or touched the columns in question. The formula simply sits in the cell, looking at me--I don't even get an error.
I am totally out of my league. Can anyone help?
Bookmarks