Easy question, I think....

[srcurrie]

When using VLOOKUP (which I FINALLY have figured out) I am trying to figure out how to get the cell information to complete after only a couple of letters or numbers are typed. Is this possible?
My current formula is written as:
=vlookup(a1,sales!,a1:c308,2,false)

As usual, many thanks.

 

[Ian Mac]

Select the list you have on the other sheet. You can do 1 of 2 things:

Either type a word/name in the Name Box, top left of the work sheet, next to the '=' sign. Make the word as relivant as possible e.g. PartsList or DayOfWeek.

Or, select the list goto Insert>Names>Define and Type the name you want.


Next:
Goto the sheet you want to use to select that list, highlight the column or area you need. goto Data>Validation>List (from the drop down list. then in Source type '=' and then the name of the list i.e. =PartsList. press OK.

hope this helps

 

[srcurrie]

Ian Mac,
Thanks so much, I got it. Just 1 thing can you reference another .xls file instead of a sheet in the workbook?

 

[Ian Mac]

NO

 

[Aladin Akyurek]

On 2002-03-27 05:53, srcurrie wrote:
Ian Mac,
Thanks so much, I got it. Just 1 thing can you reference another .xls file instead of a sheet in the workbook?

No.

 

[srcurrie]

Thanks to all for the help.