Ask Experts Questions for FREE Help !
Ask
    stephdrummond's Avatar
    stephdrummond Posts: 1, Reputation: 1
    New Member
    		  
    #1

    Dec 8, 2003, 10:38 AM
    Excel question
    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??

    mark62234's Avatar
    mark62234 Posts: 1, Reputation: 1
    New Member
    		  
    #2

    Jan 17, 2004, 12:05 AM
    Re: Excel question
    ;)

    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 :)
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Excel question [ 10 Answers ]

I've got a spreadsheet of 1688 rows. I only want rows 1, 9, 17, 25, 33, etc. (deleting 7 lines between each one I want to keep). I don't want to just delete the contents of the other lines, I want to delete the lines themselves, so that I end up with current rows 1, 9, 17 etc. being 1, 2, 3...

Question about MS Excel [ 1 Answers ]

Hi, I want to copy & transpose the content of one spreadsheet to another without cell reference changing. It seems that I just cannot use Paste Link and Transpose at the same time. What should I do? Thanks in advance, Wei

QUestion Excel [ 1 Answers ]

Hello, my name is Carmen and I live in Mexico, City. I don' t speak English very well but I try to state my question: In Excel I want to put in order some data for some column. I use the "hierarchy" function because I want a number of the order for the column "grade". But in this function I...

View more questions Search