Formula help

  • Thread starter Thread starter conniefitzgerald
  • Start date Start date
C

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?
 
conniefitzgerald said:
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?
Click to expand...


Take a look here:

http://www.contextures.com/xlFunctions03.html#Match
 
conniefitzgerald said:
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?
Click to expand...


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

http://www.contextures.com/xlFunctions03.html#IndexMatch
 
*=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.
 
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
 
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)*
 
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.
 
Well, thankfully I knew enough to not use the asterisks. It worked like a
charm. Thank you!
 
Back
Top