| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Text Formula Question
What I would like to do is the following:
Say I have 2 spreadsheets in a workbook, say A and B. In spreadsheet A, I have a database or list. For example, in column a I have a ticker symbol (MOT), column b the company name (Motorola) and in column c I have a ID # (0000111). Now I switch over to spreadsheet B to do some work...what I want to create is a formula for if I type in the ticker symbol "MOT" in say column a, column b and c will automatically fill in the company name and ID # from the spreadsheet A. My entries arent in the same order as they are listed in the database...is there a way to do this? I cant seem to figure it out, hope my wording isnt too confusing, thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Formula Question
Look in the help index for VLOOKUP making sure to use the last parameter
since not in order. -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... What I would like to do is the following: Say I have 2 spreadsheets in a workbook, say A and B. In spreadsheet A, I have a database or list. For example, in column a I have a ticker symbol (MOT), column b the company name (Motorola) and in column c I have a ID # (0000111). Now I switch over to spreadsheet B to do some work...what I want to create is a formula for if I type in the ticker symbol "MOT" in say column a, column b and c will automatically fill in the company name and ID # from the spreadsheet A. My entries arent in the same order as they are listed in the database...is there a way to do this? I cant seem to figure it out, hope my wording isnt too confusing, thanks! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Formula Question
=vlookuo(a2,sheet1!$a$2:$x$200,2,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... Don, thanks for the reply...i looked up VLOOKUP and found the formula, but i still cant seem to make it work...the formual inputs are a bit confusing...any suggestions, sorry? "Don Guillett" wrote: Look in the help index for VLOOKUP making sure to use the last parameter since not in order. -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... What I would like to do is the following: Say I have 2 spreadsheets in a workbook, say A and B. In spreadsheet A, I have a database or list. For example, in column a I have a ticker symbol (MOT), column b the company name (Motorola) and in column c I have a ID # (0000111). Now I switch over to spreadsheet B to do some work...what I want to create is a formula for if I type in the ticker symbol "MOT" in say column a, column b and c will automatically fill in the company name and ID # from the spreadsheet A. My entries arent in the same order as they are listed in the database...is there a way to do this? I cant seem to figure it out, hope my wording isnt too confusing, thanks! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Formula Question
Don,
Your a life saver, thank you very much!!!! Chris "Don Guillett" wrote: =vlookuo(a2,sheet1!$a$2:$x$200,2,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... Don, thanks for the reply...i looked up VLOOKUP and found the formula, but i still cant seem to make it work...the formual inputs are a bit confusing...any suggestions, sorry? "Don Guillett" wrote: Look in the help index for VLOOKUP making sure to use the last parameter since not in order. -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... What I would like to do is the following: Say I have 2 spreadsheets in a workbook, say A and B. In spreadsheet A, I have a database or list. For example, in column a I have a ticker symbol (MOT), column b the company name (Motorola) and in column c I have a ID # (0000111). Now I switch over to spreadsheet B to do some work...what I want to create is a formula for if I type in the ticker symbol "MOT" in say column a, column b and c will automatically fill in the company name and ID # from the spreadsheet A. My entries arent in the same order as they are listed in the database...is there a way to do this? I cant seem to figure it out, hope my wording isnt too confusing, thanks! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Formula Question
Now if I could only spell vlllllookkkup
-- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... Don, Your a life saver, thank you very much!!!! Chris "Don Guillett" wrote: =vlookuo(a2,sheet1!$a$2:$x$200,2,0) -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... Don, thanks for the reply...i looked up VLOOKUP and found the formula, but i still cant seem to make it work...the formual inputs are a bit confusing...any suggestions, sorry? "Don Guillett" wrote: Look in the help index for VLOOKUP making sure to use the last parameter since not in order. -- Don Guillett Microsoft MVP Excel SalesAid Software "Chris" wrote in message ... What I would like to do is the following: Say I have 2 spreadsheets in a workbook, say A and B. In spreadsheet A, I have a database or list. For example, in column a I have a ticker symbol (MOT), column b the company name (Motorola) and in column c I have a ID # (0000111). Now I switch over to spreadsheet B to do some work...what I want to create is a formula for if I type in the ticker symbol "MOT" in say column a, column b and c will automatically fill in the company name and ID # from the spreadsheet A. My entries arent in the same order as they are listed in the database...is there a way to do this? I cant seem to figure it out, hope my wording isnt too confusing, thanks! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Text Formula Question
Use this formula in the column for description cell on "SHEET B" the only
option that may need to be changed in these formulas is the sheet name, I have used SHEET1 =IF(ISNA(VLOOKUP(TEXT(A1,"000000"),SHEET1!$A$2:$S$ 5000,2,FALSE)),"",VLOOKUP(TEXT(A1,"000000"),SHEET1 !$A$2:$S$5000,2,FALSE)) Use this formula in the column for ID# on "SHEET B" =IF(ISNA(VLOOKUP(TEXT(A1,"000000"),SHEET1!$A$2:$S$ 5000,3,FALSE)),"",VLOOKUP(TEXT(A1,"000000"),SHEET1 !$A$2:$S$5000,3,FALSE)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| Advanced formula/inserting text question | Excel Worksheet Functions | |||
| Text to Columns Question | Excel Worksheet Functions | |||
| Text box question | Excel Discussion (Misc queries) | |||
| Text box question | Excel Discussion (Misc queries) | |||
Linear Mode
