Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering several pieces of info by typing just 1 defined name
I am trying to enter horse pedigrees to a sale catalog. I am wanting to be
able to type in M_1 and it will produce the 3 generation pedigree. I have the pedigrees all entered on one worksheet but the catalog is on a different worksheet. What can I do? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Entering several pieces of info by typing just 1 defined name
Hi,
Without your data layout it's hard to be precise but I imagineyou must have a table like this somewhere which in my case is in columns A & B of sheet 2 Col A Col B M_1 A nice horse out of a donkey M_2 A donkey out of a nice horse M_3 Dam good sire iffy Say you enter the reference M_1 in A1 of sheet 1 you could have this formula in B1 =VLOOKUP(A1,Sheet2!A1:B3,2,FALSE) Mike "Clueless" wrote: I am trying to enter horse pedigrees to a sale catalog. I am wanting to be able to type in M_1 and it will produce the 3 generation pedigree. I have the pedigrees all entered on one worksheet but the catalog is on a different worksheet. What can I do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect cell with formula from being entering info | Excel Worksheet Functions | |||
Finding pieces of a value in a table | Excel Discussion (Misc queries) | |||
entering info into different worksheets | New Users to Excel | |||
getting info into a new tab and changes when entering in other tab | Excel Worksheet Functions | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) |