Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

# help with a formula for Excel

### #1 diggeryo Posted 25 September 2006 - 12:38 PM

diggeryo

Member

• Member
• 343 posts
I have Excel 2003. I don't even know if what I'm trying to do is possible, but so far everything I've tried doesn't work.

Here's the scenerio:

I have 3 columns.
Column A has phone numbers in rows 2 through 1121 (with a header in row 1).
Column B has phone numbers in rows 2 through 6324 (with a header in row 1).
In column C, I would like to put a formula that would put an asterick in column C if the phone number column B is anywhere in Column A.

For example, if the phone number in row 5/column B is equal to the phone number in any row of column A, I'd like an asterick in row 5/column C.

So far, I tried this: in row 2/column C, I typed: =if(B2=A:A,"*","")
and then I copied the formula into each row in column C. But it doesn't seem to work.

any help is appreciated.

thanks,
mike.

Edited by diggeryo, 25 September 2006 - 12:39 PM.

• 0

### #2 diggeryo Posted 25 September 2006 - 01:18 PM

diggeryo

Member

• Topic Starter
• Member
• 343 posts
I figured it out. After a lot more searching, I came across a formula called Match.

thanks though,
mike.
• 0

### Similar Topics

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users