Formulas

[Tim]

I need to have a cell on the first sheet in a work book
be the referance for anothother cell. The name of suite
number and name of tenant is on one wksheet I want to
everytime I enter a new suite number on a diffet sheet in
the same wkbook have it return the tenant's name. Does
anyone know the formula I can use to do this?

 

[Gord Dibben]

Tim

Sheet1 Column A contains suite numbers.

Sheet1 Column B contains tenants.

Sheet2 A1 is where you enter a suite number that would be on Sheet1.

Sheet2 B1 enter =VLOOKUP(A1,Sheet1!$A$1:$B$100,2,FALSE)

Sheet2 B1 will return the tenant associated with the number you enter in A1

Gord Dibben XL2002