Solved: Matching two sheets help needed

[majaro]

I need to match what is in column G of the sheet labeled IDX0508 to the sheet Hierarchy Columns Q and R for a match. The data in column G of IDX0508 could be in either column of the sheet Hierarchy.

I would like to have the word ?Match? or ?No Match? appear in column U of the IDX0508 sheet depending on the test results. Spreadsheet attached. Thanks.

[Bob Phillips]

=IF(ISNA(MATCH(G11,Hierarchy!Q:Q,0)),IF(ISNA(MATCH(G11,Hierarchy!R:R,0)),"No match","Match in R"),"Match in Q")

[majaro]

Thanks Sid. As usual flawless.

[Aussiebear]

Hmmm... "Sid"?

[Simon Lloyd]

See Bob all that time ago i told ya' The Great El Cid!

[Bob Phillips]

I keep thinking he is referring back to the Sid in the British Gas advert.

[majaro]

First of all my apologies Bob. I need to alter the formulat you gave me to instead of placing the words match or no match in the cell, i need to put the actual value of the cell. So instead of match put the value of the cell beig matched. Thanks BOB!! :hi: