View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hobbes2006 Hobbes2006 is offline
external usenet poster
 
Posts: 4
Default 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?