Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find mulitple records Vlookup type function?
Hello,
I have two spreadsheets. SheetA contains mulitple records of the same invoice, each record contains the invoice number in the INVNBR column but provides details on different rows of the invoice. SHEETB contains a list of invoice numbers (and other data). I would like to be able to perform something like a vlookup using the SHEETB Invoice Number to find all instances of the SHEETA Invoice Number. Unfortunately Vlookup only returns the first exact match it finds even if there are more exact matchs in SHEETB. Is there such an animal without resorting to Visual Basic or some other language? Thanks, Kerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy specific records from mulitple wks to single wks | Excel Programming | |||
mulitple worksheets vlookup | Excel Discussion (Misc queries) | |||
changing the default type of searching in the find function | Excel Discussion (Misc queries) | |||
Can VLookup function find and list multiple records? | Excel Worksheet Functions | |||
Mulitple conditonal match / Vlookup | Excel Worksheet Functions |