Thread: How to fill columns based on other values

Hi,

I am attaching an excel workbook which has two sheets. Sheet1 and Sheet2. Sheet1 has columns ITEM Shipment Number Task Number / Debrief Number RECEIPT_DATE RECEIPT NUMBER

and Sheet2 has TASK_NUM DEBRIEF_NUMBER RECEIPT_DATE SHIPMENT_NUM RECEIPT_NUMBER.

In sheet1 I want to populate the columns RECEIPT_DATE and RECEIPT_NUMBER automatically from Sheet 2 based on the correct comparison. Can someone help me .

Thanks

Please help me with this. It is really urgent

Try this...

On sheet1 in cell D2 enter this formula:

=INDEX(Sheet2!$C$2:$C$7,MATCH(Sheet1!B2&Sheet1!C2,Sheet2!$D$2:$D$7&Sheet2!$A$2:$A$7,0))

MAKE SURE YOU HIT CONTROL+SHIFT+ENTER after to type the formula to enter it as an array. also make sure you have the receipt date column formatted to display date otherwise you might not get the right value.
After you enter the formula in cell D2 drag it down to populate the rest of the column.

Same process for column E...

In cell E2 Enter...
=INDEX(Sheet2!$E$2:$E$7,MATCH(Sheet1!B2&Sheet1!C2,Sheet2!$D$2:$D$7&Sheet2!$A$2:$A$7,0))

don't forget the CONTROL+SHIFT+ENTER

then drag it down.

Hope this helps.