Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP help....select like names and enter sales
I am trying to find matching names in two workbooks and select volume.
here's an example: Work book A (F2)Full Name Oct Smith,Ronnie 5,843 Work book B (k2)Full name (L2) Nov Robertson, Richard 11,000 Smith, Ronnie 12,000 What i want is this: Full Name Oct Nov Smith, Ronnie 5,843 12,000 Heres my lookup i am using: =LOOKUP(F2,K$2:K$1793,L$2:L$1794) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP help....select like names and enter sales
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results. -- Don Guillett Microsoft MVP Excel SalesAid Software "pm" wrote in message ... I am trying to find matching names in two workbooks and select volume. here's an example: Work book A (F2)Full Name Oct Smith,Ronnie 5,843 Work book B (k2)Full name (L2) Nov Robertson, Richard 11,000 Smith, Ronnie 12,000 What i want is this: Full Name Oct Nov Smith, Ronnie 5,843 12,000 Heres my lookup i am using: =LOOKUP(F2,K$2:K$1793,L$2:L$1794) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to enter a name in one cell, and have it return their sales $. | Excel Discussion (Misc queries) | |||
Macro to select cells in column enter data then press enter | New Users to Excel | |||
Enter credit (negative number) in sales template | Excel Discussion (Misc queries) | |||
changing names in Cells of the Sales Pipeline management template? | Excel Worksheet Functions | |||
select the first cell in the next row down after pressing enter o. | Setting up and Configuration of Excel |