Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Database functions
how do i create formulas that follow a name on a different sheet. I want it
to find a name in a list on a seperate worksheet and perform the calculations using values in set columns in the record. I a |
#2
|
|||
|
|||
"easygoer714" wrote: how do i create formulas that follow a name on a different sheet. I want it to find a name in a list on a seperate worksheet and perform the calculations using values in set columns in the record. I also want these calculations to follow their set record even if that record moves. Also, the value i want it to look up in the seperate datasheet is in the datasheet i want the formulas in. |
#3
|
|||
|
|||
Hi
not really sure what you're trying to do. Could you give a more specific example -- Regards Frank Kabel Frankfurt, Germany "easygoer714" schrieb im Newsbeitrag ... how do i create formulas that follow a name on a different sheet. I want it to find a name in a list on a seperate worksheet and perform the calculations using values in set columns in the record. I a |
#4
|
|||
|
|||
"Frank Kabel" wrote: Hi not really sure what you're trying to do. Could you give a more specific example -- Regards Frank Kabel Frankfurt, Germany "easygoer714" schrieb im Newsbeitrag ... how do i create formulas that follow a name on a different sheet. I want it to find a name in a list on a seperate worksheet and perform the calculations using values in set columns in the record. I a I am working on a workbook and i want to make a formula that will find someone's name in a worksheet and use the values in the same row in set columns to evaluate the formula. It will be nested with a countif function. I need it to use the values with the specified name even if the record on the other datasheet moves to a new row #. |
#5
|
|||
|
|||
I'm not sure how you're nesting with COUNTIF(), but you can, if the name
is in the left-hand column of your lookup range, use VLOOKUP (else use INDEX(MATCH()): B1: =VLOOKUP($A1, Sheet2!A:F, 2, 0 C1: =VLOOKUP($A1, Sheet2!A:F, 3, 0) .... In article , "easygoer714" wrote: I am working on a workbook and i want to make a formula that will find someone's name in a worksheet and use the values in the same row in set columns to evaluate the formula. It will be nested with a countif function. I need it to use the values with the specified name even if the record on the other datasheet moves to a new row #. |
#6
|
|||
|
|||
Hi
have a look at VLOOKUP. See:; http://www.contextures.com/xlFunctions02.html -- Regards Frank Kabel Frankfurt, Germany "easygoer714" schrieb im Newsbeitrag ... "Frank Kabel" wrote: Hi not really sure what you're trying to do. Could you give a more specific example -- Regards Frank Kabel Frankfurt, Germany "easygoer714" schrieb im Newsbeitrag ... how do i create formulas that follow a name on a different sheet. I want it to find a name in a list on a seperate worksheet and perform the calculations using values in set columns in the record. I a I am working on a workbook and i want to make a formula that will find someone's name in a worksheet and use the values in the same row in set columns to evaluate the formula. It will be nested with a countif function. I need it to use the values with the specified name even if the record on the other datasheet moves to a new row #. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
Need help with exel database | Excel Discussion (Misc queries) | |||
How do I create a "List If" function.I need to search a database . | Excel Worksheet Functions | |||
Searchable Database | Excel Worksheet Functions | |||
Multi pick into database | Excel Worksheet Functions |