ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can vlookup be used to if the lookup values are in two columns? (https://www.excelbanter.com/excel-worksheet-functions/121106-can-vlookup-used-if-lookup-values-two-columns.html)

Hobbes2006

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