Not sure what function to use

[cjjcmg]

The basic question is: if A1 = colB rowX, (X being any row MATCHed to A1), use data in colC rowX

I have used multiple columns with MATCH and CONCATENATE, copy and paste special data twice, but I'd rather enter one eq and be done.

Thanks!!!!

 

[Marcelo Branco]

Welcome to Mr Excel forum

Your question is not clear.
Maybe the combination INDEX and MATCH does what you need.
Something like
=INDEX(C:C,MATCH(A1,B:B,0))

Take a look at
http://www.contextures.com/xlFunctions03.html

Hope this helps

M.

 

[cjjcmg]

You rock! My question must have been more clear than you thought. Worked perfectly!!!

Thank you Marcelo

 

[Marcelo Branco]

You are welcome. Glad to help.

M.