Need A Way To Cross Reference 2 Sheets

**anilos81** · 07-11-2008, 03:27 PM

Hi Everyone,

I am sure this is a duplicate of a thread with this question somewhere but i have tried the formulas I found in other threads and I can't find one that quite fits my needs. I am good at Excel, but I am not a pro, so please be gentle...

Here is my problem.

I have a workbook with 2 sheets. Both sheets contain many columns of date. Each sheet contains a column with purchase order numbers.

In sheet 1 I have the purchase order number, but I do not have the that the order was created.

In sheet 2 I have the purchase order AND the date the order was created.

In sheet 1 I would like to find a formula that will pull the purchase order date from sheet 2 and insert it into the appropriate column in sheet 1.

I have a feeling there is a simple solution to this, can someone please help?

Thx,
anilos81

**NBVC** · 07-11-2008, 03:29 PM

Have you tried looking into Vlookup? Review Excel help on this function...

**anilos81** · 07-11-2008, 03:34 PM

Yes that is what I have been trying. I can not find a way to get it to work for what I am trying to do though.

**NBVC** · 07-11-2008, 03:38 PM

Can you post more detail... as to what is your lookup cell reference and where exactly the data is in the other sheet...

...or post a sample workbook..with comments..

**anilos81** · 07-11-2008, 03:48 PM

Sheet 1 - Need to pull purchase order date from Sheet 2 and insert it into Column B.

Sheet 2 - Contains the purchase order date in column A.

The column the two sheets share is the purchase order number.

I have attached a workbook for your reference, I have highlighted the applicable columns in yellow.

**NBVC** · 07-11-2008, 03:55 PM

Ok, because your columns are switched around from what Vlookup requires... you need to use an Index/Match combo to workaround the lookup to the left problem

Try:

=INDEX('Sheet 2'!A:A,MATCH('Sheet 1'!D2,'Sheet 2'!B:B,0))

copied down.