|
VLOOKUP-common look up entry with multiple results
Hello...
I need to have the following in a file: Order Serial # 123 ABC 123 DEF 234 GJH 234 JKI When I vlook the order number to get the serial #'s into another file I only get the first instance... eg if I vlook the serial #'s for order 123 I only get ABC returned.....Is ther a way to get multiple results for common lookup value... Thanks |
VLOOKUP-common look up entry with multiple results
Is the sample you posted what your lookup_table looks like or, does that
show your lookup_values in the first column and the second column is the result of the formula? Need more *specific* details. -- Biff Microsoft Excel MVP "CrimsonPlague29" wrote in message ... Hello... I need to have the following in a file: Order Serial # 123 ABC 123 DEF 234 GJH 234 JKI When I vlook the order number to get the serial #'s into another file I only get the first instance... eg if I vlook the serial #'s for order 123 I only get ABC returned.....Is ther a way to get multiple results for common lookup value... Thanks |
VLOOKUP-common look up entry with multiple results
This is the result I need to see the order column is my lookup values and the
serial # is the results.....I'm looking to pull only the info I need from the master file, there is alot of info that i don't require "T. Valko" wrote: Is the sample you posted what your lookup_table looks like or, does that show your lookup_values in the first column and the second column is the result of the formula? Need more *specific* details. -- Biff Microsoft Excel MVP "CrimsonPlague29" wrote in message ... Hello... I need to have the following in a file: Order Serial # 123 ABC 123 DEF 234 GJH 234 JKI When I vlook the order number to get the serial #'s into another file I only get the first instance... eg if I vlook the serial #'s for order 123 I only get ABC returned.....Is ther a way to get multiple results for common lookup value... Thanks |
VLOOKUP-common look up entry with multiple results
See if this helps:
http://office.microsoft.com/en-ca/ex...260381033.aspx -- Biff Microsoft Excel MVP "CrimsonPlague29" wrote in message ... This is the result I need to see the order column is my lookup values and the serial # is the results.....I'm looking to pull only the info I need from the master file, there is alot of info that i don't require "T. Valko" wrote: Is the sample you posted what your lookup_table looks like or, does that show your lookup_values in the first column and the second column is the result of the formula? Need more *specific* details. -- Biff Microsoft Excel MVP "CrimsonPlague29" wrote in message ... Hello... I need to have the following in a file: Order Serial # 123 ABC 123 DEF 234 GJH 234 JKI When I vlook the order number to get the serial #'s into another file I only get the first instance... eg if I vlook the serial #'s for order 123 I only get ABC returned.....Is ther a way to get multiple results for common lookup value... Thanks |
| All times are GMT +1. The time now is 12:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com