Formulas

  • Thread starter Thread starter Tim
  • Start date Start date
T

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?
 
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
 

Ask a Question

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.

Ask a Question

Similar Threads

search all tabs for tab name specified & lookup reference? 5
Smaller than 0 to return a 0 result 1
Vlookup(lookup_value) 1
Template & Database Question 2
Vlookup and return sheet name also 2
Daily Cost & Cums 3
i AM CREATING A DATA AND WANT TO SORT, BUT KEEP DATA TOGETHER 3
Similar Book to Book Code, one works other does not 11

Back
Top