formula to return cell values

[jag108]

Hi Guys\Gals

I am trying to return a value from a cell on one sheet when a match is made, then return the value from the cell adacent from a different sheet.

Trying to use matchbut not getting the value returned that I am after.

Once agin as I feel this is difficult just to try and explain.

Col1|col2

Match the value col1 return the value in col2 to the calling sheet.

Using Excel 2010 on XP Pro SP 3

 

[T. Valko]

Sweet!

With some tweaking I made this work

INDEX('stock comparison'!A1:C12,MATCH(B4,'stock comparison'!B1:B12,0),3)

With the help of this link.

http://www.excel-examples.com/index-match.htm

Thanks guys for seeing me through this.

*Resolved*

The formula in reply #9 does the exact same thing!

Glad we got this straightened out. Thanks for the feedback!

 

[Aladin Akyurek]

Sweet!

With some tweaking I made this work

INDEX('stock comparison'!A1:C12,MATCH(B4,'stock comparison'!B1:B12,0),3)

With the help of this link.

http://www.excel-examples.com/index-match.htm

Thanks guys for seeing me through this.

*Resolved*

=INDEX('stock comparison'!$C$1:$C$12,MATCH(B4,'stock comparison'!$B$1:$B$12,0))

will suffice and it can be copied down straightaway.