hi everyone.
I have the column with title like this:
1 A B C
2 name1 name2
3 john lewiski red ffff
4 Tran micheal honduras thomas
5 don weslth rose tyref
6 tom Handerson indi mike
I want to use Vlookup and match function in cell C2 to search for EXACT Name. If it found the name, it will print out the message:
"YOU HAD THIS NAME" with the Title of the column which name is in
for example:
If I want to search for: "john lewiski" (Letter case not importance), I will have the result looklike this in cell c2:
" YOU HAD THIS NAME IN NAME1"
How can I do this by using function Vlookup and Match. all input will be greatly appreciated.
I have the column with title like this:
1 A B C
2 name1 name2
3 john lewiski red ffff
4 Tran micheal honduras thomas
5 don weslth rose tyref
6 tom Handerson indi mike
I want to use Vlookup and match function in cell C2 to search for EXACT Name. If it found the name, it will print out the message:
"YOU HAD THIS NAME" with the Title of the column which name is in
for example:
If I want to search for: "john lewiski" (Letter case not importance), I will have the result looklike this in cell c2:
" YOU HAD THIS NAME IN NAME1"
How can I do this by using function Vlookup and Match. all input will be greatly appreciated.