Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Josh O.
 
Posts: n/a
Default Return Multiple Results with Lookup

I need to set a worksheet to pull numbers from another worksheet.
The first problem is multiple values. I need the spreadsheet (sheet 2 to
list all of the invoice numbers based on a single customer number, pulling
the data from another spreadsheet (sheet 1).

Second, it would be helpful if the spreadsheet (sheet 2) can pull all the
customer numbers that appear on the original spreadsheet (sheet 1).

I tried using Alan Beban's "vlookups" to return multiple values, but I can't
figure out how to get the formula to return the multiple values into sheet 2.

I would appreciates some more ideas or suggestions
  #2   Report Post  
Harlan Grove
 
Posts: n/a
Default

Josh O. wrote...
....
I would appreciates some more ideas or suggestions


Stay in your original thread.

Reply
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
lookup multiple occurrences of a value excel ckl Excel Worksheet Functions 5 February 3rd 05 05:19 AM
How do I lookup and return different values when the lookup value. kg Excel Discussion (Misc queries) 1 January 20th 05 12:53 AM
Can VLOOKUP return multiple answers based on several identical lo. jddtct Excel Worksheet Functions 3 January 11th 05 07:03 AM
Lookup values in a list and return multiple rows of data Amanda L Excel Worksheet Functions 2 December 2nd 04 04:48 PM
How to look up and return multiple values Wendy Excel Worksheet Functions 3 November 3rd 04 04:32 PM


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

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

About Us

"It's about Microsoft Excel"