Vlookup And Multiple Arrays

    I have two column on two seperate worksheets. One worksheet has both columns filled out. On the second worksheet, I want to be able to type in info in once column and have excel pull the other column from the other worksheet.


    WKSHT 1 WKSHT 2


    ID Name ID Name
    1 Bill 3 ?VLookup?
    2 Steve
    3 Mike



    Ive tried using Vlookup('worksheet1'!A2:A4,'worksheet1'!B2:B4,2) but can not get it to work. Can anyone give some help. Thanks,
    Brian

    Re: Vlookup And Multiple Arrays


    Hi,


    Say you want the result (the formula will be) in cell A2 of worksheet2, and the formula (result) is based on an entry made in cell A1 of the same worksheet, try the following formula:


    VLOOKUP(A1,worksheet1!A1:B20,2,FALSE)


    Let me know how it goes.


    Kind regards,


    Robert
    : D

    Re: Vlookup And Multiple Arrays


    Ok, Ive included my worksheets to see if I can understand this better. The member level worksheet is the one that has the information entered into. in the deal member level worksheet I want to be able to enter in their group id # and have the vlookup function enter in the corresponding member Id #. I tried entering the formula in cell B2 but its not working... any ideas.


    Thanks,
    Brian

    Re: Vlookup And Multiple Arrays


    Hi Brain,


    I don't think the formula was the problem, more the fact that the "1" in cell A14 of the "Deal Member Level" worksheet was centred using a "^" (witches hat). Though this does centre the contents of a cell, it also converts the contents of the cell to text which in turn meant the VLOOKUP formula didn't work as the "1" on the "Member Level" was numeric (though they look identical, a numeric 1 is NOT the same as a text 1).


    Once I removed the "^" and centred the value in cell A14 via the centre text align icon on the Standard toolbar, all was OK.


    I have attached the two files in question (which I saved to my C drive) for your reference.


    Let me know how it goes.


    Kind regards,


    Robert
    : D

    Re: Vlookup And Multiple Arrays


    Robert,
    Thank you so very much. Now I can finish and get some well deserved rest.


    Thanks again,
    Brian: D

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login