I have a number of worksheets in one excel file. I have been doing VLOOKUPS but now I want to know how to get once cell to = one cell in another worksheet. I hope someone knows??

;)

I am not real sure that I know what you are asking. But if you want values to be the same or appear on another worksheet you have to request the sheet

Example:

On a workbook called vlookup1 I have an array
On a workbook called vlookup2 I have a request column B5

=VLOOKUP(B5,[vlookup1.xls]Sheet1!$15:$I$20,3,FALSE)

Hope it helps

Mark :)