LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,388
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to vlookup and bring over fill colors as along with the data dadams Excel Worksheet Functions 1 January 31st 08 06:34 PM
Log of Transactions Snakeoids Excel Discussion (Misc queries) 1 October 27th 07 12:48 AM
How do I. VLOOKUP & BRING BACK THE CELL BELOW THE CELL WHICH IS FO Chris Excel Worksheet Functions 2 November 16th 06 02:42 AM
Can you use a vlookup to bring in a picture? Marlsnz Excel Discussion (Misc queries) 1 June 2nd 06 01:59 AM
How can I bring forward formats with Vlookup? candycasey Excel Worksheet Functions 1 May 16th 06 12:47 AM


All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"