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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

just_jon

Legend
Joined
Sep 3, 2002
Messages
10,473
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"))
 

tom123

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

tom123

New Member
Joined
Jan 17, 2004
Messages
17
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??
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,560
Messages
5,765,085
Members
425,258
Latest member
brentmitchell

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
Top