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 |