Jump to content

Welcome to Geeks to Go - Register now for FREE

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
Photo

"advanced" look-up


  • Please log in to reply

#1
aj_grass

aj_grass

    Member

  • Member
  • PipPip
  • 31 posts
I'm looking for a find formula in Excel which I can't find myself. I wonder if anyone can help with the following:

I have a table of data, each colum is a name of a place (like LA, NY, etc...) and the data in each colum is a name of a person. I'm expecting not to place the same person in more than one location.

in a different place in the work-sheet I have a list of persons' names and I want to find what is their location.

So in general, I want to find in what colum a value is stored in a whole table, assuming it's shown only once.
"match" only works on an array, i.e. 1-dimentional table, which is not what I need.

Is there a way to do this? a formula I mean. Is there an add-in to Excel that has this formula?
  • 0

Advertisements


#2
aj_grass

aj_grass

    Member

  • Topic Starter
  • Member
  • PipPip
  • 31 posts
Never mind. The matter is resolved now.
i found out i can write a custom function in VBA.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP