Posted by DandBS on August 20, 2001 5:51 AM
I'm trying to use the vlookup function to summarise results from different worksheets, where:
refers to a cell as a column header with text 'Sheet1' in it.The next column header to it would have (e.g.) Sheet2. So, by dragging the cell with the formula across to the next cell, the formula would be revised to =VLOOKUP(C3,Sheet2!$A$1:$B$8,2,FALSE)
All Excel does is print the line out, rather than calculating the value, and I can't get excel to recognise this as a formula. Any ideas?