Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL SPREADSHEET SET-UP QUESTION
I have a spreadsheet with 4 tabs. Tab 4 is the master list with the
information I need. Tab 1 is a modeling spreadsheet whereby you enter information and it takes the information from tab 1 onto tab 2 which calculates the information you just entered. I am trying to create a cell on tab 1 which I can enter a property ID number and it will go to tab 4 and capture certain information in a certain cell, then transfer the information onto designated cells on tab 1. Has anyone done this before? I have seen it done where you can enter a social security number in a field and it will populate the information into the cells. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
EXCEL SPREADSHEET SET-UP QUESTION
I believe you're looking for VLOOKUP. Here's a tutorial on something similar
to what you want to do: http://www.officearticles.com/tutori...soft_excel.htm And here's an explanation of VLOOKUP: http://www.officearticles.com/excel/...soft_excel.htm ************ Hope it helps! Anne Troy www.OfficeArticles.com "mayoslc" wrote in message ... I have a spreadsheet with 4 tabs. Tab 4 is the master list with the information I need. Tab 1 is a modeling spreadsheet whereby you enter information and it takes the information from tab 1 onto tab 2 which calculates the information you just entered. I am trying to create a cell on tab 1 which I can enter a property ID number and it will go to tab 4 and capture certain information in a certain cell, then transfer the information onto designated cells on tab 1. Has anyone done this before? I have seen it done where you can enter a social security number in a field and it will populate the information into the cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excel 2K3: Opening a spreadsheet, also opens book1.xls? | Excel Discussion (Misc queries) | |||
windows explorer will not open an excel spreadsheet. | Excel Discussion (Misc queries) | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
How do I export an Excel spreadsheet to Pocket PC (Pocket Excel)?. | Excel Discussion (Misc queries) |