![]() |
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? |
All times are GMT +1. The time now is 02:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com