| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup, Can I only have it bring up a transactions once?
My problem is, when I use my Vlookup formula and drag is down it will list
information for a transaction several times before list the next... How can eliminate this. How can I have it only bring up a transaction once, and the move on to the next? I appreciate any help I can get... Eample: I look for a product code and have it return the transaction code...(Transactions codes are I.E. TR55, TR56 TR57, etc...) Column: Transaction Code for Product ### TR55 TR55 TR55 TR55 TR59 TR59 TR59 TR59 TR59 TR59 TR65 TR65 TR65 et.... TR66 TR62 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup, Can I only have it bring up a transactions once?
not sure what you mean, if the product code is listed multiple times, so will
the transaction code "Dave" wrote: My problem is, when I use my Vlookup formula and drag is down it will list information for a transaction several times before list the next... How can eliminate this. How can I have it only bring up a transaction once, and the move on to the next? I appreciate any help I can get... Eample: I look for a product code and have it return the transaction code...(Transactions codes are I.E. TR55, TR56 TR57, etc...) Column: Transaction Code for Product ### TR55 TR55 TR55 TR55 TR59 TR59 TR59 TR59 TR59 TR59 TR65 TR65 TR65 et.... TR66 TR62 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup, Can I only have it bring up a transactions once?
The product code is listed multiple times but for different transactions,
each transaction is only listed once. The TR55 that repeats is the same transaction, what I would like to do is have it list it once, TR55 and then go until it hits another transaction with that product code....Does this help clarify??? Sorry if I was confusing, Thank you for the help. "Dave" wrote: My problem is, when I use my Vlookup formula and drag is down it will list information for a transaction several times before list the next... How can eliminate this. How can I have it only bring up a transaction once, and the move on to the next? I appreciate any help I can get... Eample: I look for a product code and have it return the transaction code...(Transactions codes are I.E. TR55, TR56 TR57, etc...) Column: Transaction Code for Product ### TR55 TR55 TR55 TR55 TR59 TR59 TR59 TR59 TR59 TR59 TR65 TR65 TR65 et.... TR66 TR62 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to vlookup and bring over fill colors as along with the data | Excel Worksheet Functions | |||
| Log of Transactions | Excel Discussion (Misc queries) | |||
| How do I. VLOOKUP & BRING BACK THE CELL BELOW THE CELL WHICH IS FO | Excel Worksheet Functions | |||
| Can you use a vlookup to bring in a picture? | Excel Discussion (Misc queries) | |||
| How can I bring forward formats with Vlookup? | Excel Worksheet Functions | |||
Linear Mode
