It is true that a cell can only return one value, there is no way to put
two distinct values into one cell. Again, without know what values you
want to return, or where they come from it is hard to give a concise
answer.

It is possible a simple VLOOKUP could solve your problem, returning a
value from a table of data based on the value in A3. It could be you
need to pull data from multiple locations to do a calculation
(=sheet2!A3*sheet3!A3), and these can be further enhanced with IF, AND,
OR, SUMPRODUCT... the list goes on. I'll bet if you include some sample
data and examples of expected results, someone may come up with a
solution for you.

Good Luck

By the way..Yogi Berra is a former baseball player/manager for the NY
Yankees, famous for double talk that makes you shake your head and say
"Huh, what did he say...?" Examples: speaking of a famous restaurant
in New York City..."No one goes there anymore, it's too crowded" and
his most famous... "It ain't over til it's over!"

Cheers!


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=374134