matching values in 2 tables-vlookup

kwg

Board Regular
Joined
Apr 26, 2003
Messages
75
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

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,119
kwg said:
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.
 

Forum statistics

Threads
1,078,249
Messages
5,339,077
Members
399,276
Latest member
Donjayok

Some videos you may like

This Week's Hot Topics

Top