vlookup a value after it match 3 values

Microsoft Excel home and student 2010 so...
January 9, 2011 at 23:14:09
Specs: Windows 7
I had 2 data file with one sheet each with about 20-30 column. so were duplicated. Let say in file 1 sheet1 contain field name as A1, B1, C1, D1, ..... K1. and file 2 sheet 2 contain a1, b1, c1, d1, ....p1.
I would want to find a value from sheet 2 in column n. and input into column G of file 1 sheet1 of the correspondance row when the value of A, B and C are all match with a, b and c.(closed match of each).

row File 1 sheet 1 file 2 sheet 2
nos
A, B, C, D, ... G, .. K a, b, c, d, ..., n , .......p.

2 aa 15 0 NP ae 21 5 4

3 ac 18 2 #NA ac 18 9 70

4 ae 21 5 4 aa 15 0 NP

As in the above example, G2 is inputed with value from n2 when A2 match a2 and B2 match b2 and C2 match c2. and G3 is not inputed as can not find all 3 matches. and G4 is inputed as match had been found in row 2.

Kindly please let me know how to do it with the formulas. Thank you.



See More: vlookup a value after it match 3 values

Report •

#1
January 9, 2011 at 23:21:42
Sorry for correction on the above,
--------------------------------------------------
As in the above example, G2 is inputed with value from n4 when A2 match a4 and B2 match b4 and C2 match c4. first digit is row nos. ie, 2,3,4, and 1 is missing. the alphabet aa, ac, and ae are under column A and a of the different file respectively. and 15, 18 and 21 are under column B and so on....., thank you to the forum and whoever help me in this matter.

Report •
Related Solutions


Ask Question