Search/Lookup Problem

  • Thread starter Thread starter Simon Topping
  • Start date Start date
S

Simon Topping

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
 
Simon Topping said:
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
Click to expand...

You need a separate formula for each instance of each invoice number. Look
here in the paragraph "Arbitrary Lookups" for help with constructing the
formulas:
http://www.cpearson.com/excel/lookups.htm
 
Back
Top