Using 2 Vlookups to return a result

  • Thread starter Thread starter busterf
  • Start date Start date
B

busterf

I have an array of data that I need to first match a UPC number from
then use a corresponding date to retrieve a result from 4 rows over.
On one page will have in the first column the UPC and the second colum
the date that I want to match. In the 3rd column I need the resul
from the data array residing in a different tab or workbook. The issu
is that they dont have an intersecting point, the lookups are linear
 
Hi
not really sure what you're trying to achieve. You may post some
example rows of data (plain text - no attachments please) and describe
your expected result based on this example data
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

'RIGHT', 'LEFT' in a VLOOKUP 6
Comparing 2 blocks of text and data 2
VLOOKUP reference issue 3
Simple macro 1
formatting a lookup 4
Vlookup using 2 criteria 2
How do I combine spreadsheets? 2
Split UPC Question 2

Back
Top