I assume the cell that is being used as the reference cell is on the
open sheet and that the vlookup table is on another workbook which
should also be open:
=vlookup(a1,{at this point use the mouse to point at the range of cells
in the other workbook and drag over your chosen range, press the comma
key and enter any number for now over 1} close the formula with a )
You will need to edit the formula to ensure that you are returning the
value from the required column, to do this you will need to change the
last digit to refer to the required column
You can do a vlookup into another workbook provided it is open when you
perform this function. If you open a file which contains a vlookup
formula from another workbook it will prompt u to update links ..... if
u select to do so, you need to open that file... else it will show
error. To retain the existing values select do not update..
as far as the 2nd question goes.... it is same as any regular vlookup
formula... you can get many links on this group on how to write one.
Just lookup for vlookup.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
