matching values in 2 tables-vlookup

[kwg]

here is my question...

I have two tables 12 columns each exactly the same except:
table one is customer A and table two is customer B. I have named the numbers in each table a unique range name for each table called custA and custB.

I want to copy the value of row 6, column 3 of the second table to another worksheet as long as the word widget appears in column 1 row six of both tables.

I have tried using a combination of Vlookup, if statements, and range names with no success.

Any help is greatly appreciated!

 

[Aladin Akyurek]

here is my question...

I have two tables 12 columns each exactly the same except:
table one is customer A and table two is customer B. I have named the numbers in each table a unique range name for each table called custA and custB.

I want to copy the value of row 6, column 3 of the second table to another worksheet as long as the word widget appears in column 1 row six of both tables.

I have tried using a combination of Vlookup, if statements, and range names with no success.

Any help is greatly appreciated!

Care to post a reduced sample that illustrates the retrieval problem you want to solve.