RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hi, I know how to vlookup one value and match but I am trying to lookup and match the values of both the columns in data 1 with data 2 with the help of a formula. If both the values have an exact match then I want to display the name in data2 in column F or display “Not Found”.
qyerrt.xlsx | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Data 1 | Formula | Data 2 | ||||||||||||
2 | A | 18 | January | 1 | R | ||||||||||
3 | B | 19 | February | 2 | Q | ||||||||||
4 | C | 16 | March | 3 | P | ||||||||||
5 | D | 15 | April | 4 | O | ||||||||||
6 | E | 14 | May | 5 | N | ||||||||||
7 | F | 13 | June | 6 | M | ||||||||||
8 | G | 11 | July | 7 | L | ||||||||||
9 | H | 11 | August | 8 | K | ||||||||||
10 | I | 10 | September | 9 | J | ||||||||||
11 | J | 9 | October | 10 | I | ||||||||||
12 | K | 8 | November | 11 | H | ||||||||||
13 | L | 5 | December | 12 | G | ||||||||||
14 | M | 6 | January | 13 | F | ||||||||||
15 | N | 5 | February | 14 | E | ||||||||||
16 | O | 4 | March | 15 | D | ||||||||||
17 | P | 2 | April | 16 | C | ||||||||||
18 | Q | 2 | May | 17 | B | ||||||||||
19 | R | 1 | June | 18 | A | ||||||||||
Sheet1 |