| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
can vlookup be used to if the lookup values are in two columns?
In one worksheet, I have a list order numbers and line numbers.
In a separate worksheet, I have a list of order numbers, line numbers, and other data about the order, such as date shipped. I want to be able to get the date shipped from Sheet 2 for order and line numbers in Sheet 1. I have to match the order and line numbers to find the correct data. Also, in Sheet2, there may be multiple lines for some order/line numbers. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
| Getting values from columns into one cell | Excel Discussion (Misc queries) | |||
| lookup mutliple values to return one value | Excel Worksheet Functions | |||
| Lookup Table Dilemma | Excel Worksheet Functions | |||
| Need help with lookup and comparing values | Excel Worksheet Functions | |||
Linear Mode
