Formula HELP!

Sue

New Member
Joined
Oct 27, 2002
Messages
2
I need to lookup or compare a list of names in Column A (always alphabetical) against a shorter list of names in Column C and if a name is found, I need the value in Column D placed in Column B. If the name in Column A is NOT found in Column C, then it needs to have some non-numerical result placed in Column B.

The following pic will help to explain. The yellow column B should be the results obtained. The 'n/a' can be any non-numeric character or characters.

excel.jpg
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
this is fairly straightforward I think (unless you have any tricks up your sleeve Sue)

In B2 enter the following formula:

=IF(ISNA(VLOOKUP(A1,C:D,2,FALSE),"n/a",VLOOKUP(A1,C:D,2,FALSE))

and then copy the formula down Column B - that should do the trick.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
One of:

=VLOOKUP(A2,$C$2:$D$8,2,0)

=IF(ISNUMBER(MATCH(A2,$C$2:$C$8,0)),VLOOKUP(A2,$C$2:$D$8,2,0),"n/a")
 

Sue

New Member
Joined
Oct 27, 2002
Messages
2
Thanks tons....you guys are the best! Knew it had to be something not too complicated, but guess I was having a dumb moment.......THANKS AGAIN!!
 

Forum statistics

Threads
1,144,274
Messages
5,723,442
Members
422,497
Latest member
dougy99

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