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?
|