IF and LOOKUP functions

[J.Bennett]

I have one spreadsheets with two tabs - one is called full and one is called
partial. What I would like to do is is pull information from full sheet to
partial, i.e. if in the full sheet there are six lines with the number 1234
in cell A and 6 lines of numbers in cell B, I would like to get them over to
cell B on one line in the partial sheet that has 1234 in cell A. I hope
I've made sense. thanks much! JBennett

 

[Dave D-C]

.. there are six lines with the number 1234 in cell A ..
Do you mean six rows with the number 1234 in column A?

.. would like to get them over to cell B on one line ..

Give an example.

 

[Pete_UK]

You might find this article to be useful:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

Hope this helps.

Pete