Excel question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dannyboy8 - 09 May 2008 16:21 GMT

I have what I would think is a fairly simple function that I cannot get for
the life of me, if I am looking to write a formula on one spreadsheet using
the intersection of 2 values (actual words in this case) can I write a
formula that will search vertically for one of the words then search
horizontally for the other word and return the value of where these 2
searches meet? I have tried VLOOKUP, HLOOKUP, MATCH and INDEX and am coming
up short, any help would be most appreciated!

Reply to this Message

Peo Sjoblom - 09 May 2008 16:28 GMT

=INDEX(A1:D20,MATCH(H1,A1:A20,0),MATCH(H2,A1:D1,0))

adapt to fit

Signature

Regards,

Peo Sjoblom

>I have what I would think is a fairly simple function that I cannot get for
> the life of me, if I am looking to write a formula on one spreadsheet
[quoted text clipped - 5 lines]
> coming
> up short, any help would be most appreciated!

Reply to this Message

dannyboy8 - 09 May 2008 18:00 GMT

Peo, in the match functions, can i use words i quotation marks as opposed to
a cell reference?

> =INDEX(A1:D20,MATCH(H1,A1:A20,0),MATCH(H2,A1:D1,0))
>
[quoted text clipped - 9 lines]
> > coming
> > up short, any help would be most appreciated!

Reply to this Message

Peo Sjoblom - 09 May 2008 18:11 GMT

Yes

Signature

Regards,

Peo Sjoblom

> Peo, in the match functions, can i use words i quotation marks as opposed
> to
[quoted text clipped - 14 lines]
>> > coming
>> > up short, any help would be most appreciated!

Reply to this Message

dannyboy8 - 09 May 2008 18:43 GMT

WORKS, THANKS!

> Yes
>
[quoted text clipped - 16 lines]
> >> > coming
> >> > up short, any help would be most appreciated!

Reply to this Message