| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"lookup" formulas
Please could someone help me with look up tables.
I have 2 different worksheets within one spreadsheet. The one worksheet contains an account number eg 00 00000 000 with an account name in the column adjacent to the account number. The other shows just the account number and payment amount. Is there any formula i could use which looks up the account name from the one worksheet and adds the account name next to the number in another worksheet? I have thousands of entries to complete so any help at all would br brilliant. Thanks -- RMP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup using 2 cells as the "X" and "Y" coordinates.... | Excel Worksheet Functions | |||
| Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
| Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
