list column title using vlookup and Match function

tom123

New Member
Joined
Jan 17, 2004
Messages
17
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.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
There must be a simplier formula to add 1/2 to NAME, but seeif this'll do for the time being --
Book1
ABCD
1johnlewiski
2name1name2YOUHADTHISNAMEINNAME1
3
4johnlewiskiredffff
5Tranmichealhondurasthomas
6donweslthrosetyref
7tomHandersonindimike
Sheet2

in C2: =IF(ISNUMBER(MATCH(C1,A4:A7,0)),"YOU HAD THIS NAME IN NAME1",IF(ISNUMBER(MATCH(C1,B4:B7,0)),"YOU HAD THIS NAME IN NAME2","NAME NOT FOUND"))
 
Upvote 0
Thank you Just_jon for your quick replied. is this working for 5 or 6 columns ?? Because in future the list will be growing, I plan to have max of six column of names for each worksheet (about 2000 names altogether).
I'll try your formular and let you know. Thanks again.
 
Upvote 0
Is it possible to add something in formular that when the message print:
"Name Not Found" it will ask that:" Add new Name to list?" with the popup box with "Yes" and "no", if I choose "Yes" it will add new name to the correspondent column??
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,268
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top