HELP! Excel 2010 How to return Multiple Corresponding Values between 2 sheets using Index and Match Formula

[JennMu]

Hi All,

I hope you are well.

HELP!

I would appreciate an immediate response as to why the below formula is not working between two Excel 2010 Worksheets.

I need to return the Corresponding Values between 2 sheets using Index and Match Formula. Below is the formula and corresponding Worksheets. Appreciate your help. The result is that I need the Vendor Name to appear on Worksheet 1 for each of the corresponding line items that have the same Sub-Project ID number.

See below

=IF(COUNTIF('PO Comm'!$G:$G, $G9)<column(g1),index('po p="" Comm?!$G:$G,0)+(COLUMN(G1)-1)))<="" Comm?!$K:$K,MATCH($G9,?PO=""></column(g1),index('po>

<tbody>
</tbody>

Worksheet 1
[TABLE="class: grid, align: left"]
<tbody>[TR]
[TD]Vendor Name Formula
[/TD]
[TD]Sub-Project
[/TD]
[/TR]
[TR]
[TD]

=IF(COUNTIF('PO Comm'!$G:$G, $G9)<column(g1),index('po p="" Comm?!$G:$G,0)+(COLUMN(G1)-1)))<="" Comm?!$K:$K,MATCH($G9,?PO=""></column(g1),index('po>

<tbody>
</tbody>

[/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
</tbody>[/TABLE]

















Worksheet 2

[TABLE="class: grid, align: left"]
<tbody>[TR]
[TD]Vendor Name
[/TD]
[TD]Sub-Project
[/TD]
[/TR]
[TR]
[TD]

TECHNOLOGY CONSULTING ASSOC LLC

<tbody>
</tbody>

[/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
[TR]
[TD]

TECHNOLOGY CONSULTING ASSOC LLC <tbody> </tbody>

<tbody>
</tbody>

[/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
[TR]
[TD]

INTERNATIONAL EXHIBITION

<tbody>
</tbody>

[/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
[TR]
[TD]

HEALTH

<tbody>
</tbody>

[/TD]
[TD]MK-USUSA16L-IM-02-04
[/TD]
[/TR]
</tbody>[/TABLE]