Search/Lookup Problem

Giganews Newsgroups
Subject: Search/Lookup Problem
Posted by:  Simon Topping (anonymo…@discussions.microsoft.com)
Date: Fri, 31 Oct 2003

Hi,

I have a large list of invoice numbers, for which there
can be more than 1 set of data, and I have no other value
that could be used as a lookup value etc.

Given something like:

      Col A  Col B

Row 1  123354    20
Row 2  114868  1235
Row 3  123354  400
Row 4  123354  546
Row 5  194583    2

How could I get separate sheet to lookup the invoice
numbers in Col A, then return the respective Col B value,
without returning the same number twice, eg

123354    20
123354  400
123354  546
114868  1235
194583    2

Any help would be greatfully received.

Cheers

Simon

Replies