Formula help

[conniefitzgerald]

I am hoping that you can help me with a formula

I want to look up data in one column and search for a specific value and
then return a value from the same row, several columns before.

I want to search for the number 1 in G7:G23
If 1 shows up in G18, I want to have the contents of A18 appear in the new
cell

Any suggestions?

 

[Glenn]

I am hoping that you can help me with a formula

I want to look up data in one column and search for a specific value and
then return a value from the same row, several columns before.

I want to search for the number 1 in G7:G23
If 1 shows up in G18, I want to have the contents of A18 appear in the new
cell

Any suggestions?

Take a look here:

http://www.contextures.com/xlFunctions03.html#Match

 

[Glenn]

I am hoping that you can help me with a formula

I want to look up data in one column and search for a specific value and
then return a value from the same row, several columns before.

I want to search for the number 1 in G7:G23
If 1 shows up in G18, I want to have the contents of A18 appear in the new
cell

Any suggestions?

Actually, look here (just a little farther down the page):

http://www.contextures.com/xlFunctions03.html#IndexMatch

 

[T. Valko]

*=INDEX(A7:A23,MATCH(1,G7:G23,0),1)*

I would recommend that you not include the * in your replies. Some folks
will think those are part of the formula.

 

[Andy Pope]

Hi JBeaucaire,

You did make the formula you posted bold though.
Many posters are using the newgroups via nntp rather than web portals.

Cheers
Andy

 

[T. Valko]

I'm using Outlook Express to access the groups. In OE the formula is
displayed as:

*=INDEX(A7:A23,MATCH(1,G7:G23,0),1)*

 

[Shane Devenshire]

Hi,

I'm using the Web portal and this shows up with *'s

 

[Pete_UK]

I see it the same way as Biff, viewed through Google Groups.

Pete

 

[Shane Devenshire]

Hi,

You can use
=LOOKUP(1,G7:G23,A7:A23)
or
=OFFSET(A6,MATCH(1,G7:G23,0),)
or
=INDEX(A7:A23,MATCH(1,G7:G23,0))

or replace the 1 with a cell reference.

 

[conniefitzgerald]

Well, thankfully I knew enough to not use the asterisks. It worked like a
charm. Thank you!