# Getting column number from HLOOKUP?

1. ## Getting column number from HLOOKUP?

I'm doing a simple HLOOKUP and would like to know what column a
matching value is in rather than the value of something else in a
nearby row.

For example if I have:

apple orange pear

in columns 1, 2, and 3 respectively, how do I do a search for "orange"
and then return the column number "2" as the match?

Thanks for any ideas!

2. ## Re: Getting column number from HLOOKUP?

=MATCH("orange",A1:D1,0)

Regards,
KL

<robotman@gmail.com> wrote in message
> I'm doing a simple HLOOKUP and would like to know what column a
> matching value is in rather than the value of something else in a
> nearby row.
>
> For example if I have:
>
> apple orange pear
>
> in columns 1, 2, and 3 respectively, how do I do a search for "orange"
> and then return the column number "2" as the match?
>
> Thanks for any ideas!
>

3. ## Re: Getting column number from HLOOKUP?

Assuming that A1:C1 contains the data, try...

=MATCH("orange",A1:C1,0)

Hope this helps!

robotman@gmail.com wrote:

> I'm doing a simple HLOOKUP and would like to know what column a
> matching value is in rather than the value of something else in a
> nearby row.
>
> For example if I have:
>
> apple orange pear
>
> in columns 1, 2, and 3 respectively, how do I do a search for "orange"
> and then return the column number "2" as the match?
>
> Thanks for any ideas!

4. ## Re: Getting column number from HLOOKUP?

Ah...thanks! Now I have a new problem with the match. For some reason
MATCH isn't finding matching dates. I'll start a new topic

Domenic wrote:
> Assuming that A1:C1 contains the data, try...
>
> =MATCH("orange",A1:C1,0)
>
> Hope this helps!
>
> robotman@gmail.com wrote:
>
> > I'm doing a simple HLOOKUP and would like to know what column a
> > matching value is in rather than the value of something else in a
> > nearby row.
> >
> > For example if I have:
> >
> > apple orange pear
> >
> > in columns 1, 2, and 3 respectively, how do I do a search for "orange"
> > and then return the column number "2" as the match?
> >
> > Thanks for any ideas!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1