VLookup or Match?

[Koda7]

Hi...I've attached a file in which I'm having trouble coming up with a working formula.

I need a formula in Column A of the Data tab, that will go all the way down Column A, that will look at both columns G & H on the same tab, then look them up on the List tab in Col B & C, once its found the match, I want the contents of Col D (on the List tab) to show up in the cells in Col A of the Data tab. Make sense?

ie. in row 2, G & H both have Business Agility in them, on the list tab on row 3, Business Agility appears in both Col B & C. Therefore, I want Other/Unassigned to appear in cell A2 of the data tab.

There may be some items in Cols G & H that don't show up on the list tab together, in which case it should return a blank cell.

[JBeaucaire]

Missing your file, try zipping if it's too big.

[Koda7]

Missing your file, try zipping if it's too big.

Sorry about that, I'm having trouble loading the file. keep getting an error message, but will try again.

[Koda7]

Here's the file

[JBeaucaire]

To create a quick key, put this formula in G3 on the LISTS page and copy down:

=B3&"|"&C3

Then on the DATA sheet, put this in A2 and copy down:

=IF(ISNUMBER(MATCH(G2&"|"&H2, List!$G:$G, 0)), INDEX(List!$D:$D, MATCH(G2&"|"&H2, List!$G:$G, 0)), "")