Question:
Dear Sir,
kindly advise how i can combine VLOOKUP with LOOKUP in one formula. because i like to search for a specific number in two execl sheet & if the number not found in the first sheet it should give me the result from the second sheet.
Appreciate your quick response.
Best Regards
R*******n A***u
Answer:
Suppose sheet1 has :
A | B
Dear Sir,
kindly advise how i can combine VLOOKUP with LOOKUP in one formula. because i like to search for a specific number in two execl sheet & if the number not found in the first sheet it should give me the result from the second sheet.
Appreciate your quick response.
Best Regards
R*******n A***u
Answer:
Hi there,
Suppose sheet1 has :
-----------------------
1 | 1 | A
2 | 2 | B
3 | 3 | C
4 | 4 | D
5 | 5 | E
1 | 1 | A
2 | 2 | B
3 | 3 | C
4 | 4 | D
5 | 5 | E
And Sheet2 has
A | B
-----------------------
1 | 6 | AA
2 | 7 | BB
3 | 8 | CC
4 | 9 | DD
5 | 10 | EE
A | B
-----------------------
1 | 6 | AA
2 | 7 | BB
3 | 8 | CC
4 | 9 | DD
5 | 10 | EE
Let's assume that your search value is in D1
=IFERROR(VLOOKUP(D1,Sheet1!A1:
=IFERROR(VLOOKUP(D1,Sheet1!A1:
X = formula in Green
Y = formula in Cyan
If X is valid then it will give result. If there is error in X then return Y.
Hope this makes sense.
Regards,
Kamal