IF and LOOKUP functions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

J.Bennett - 06 Feb 2008 17:00 GMT

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

Reply to this Message

Dave D-C - 07 Feb 2008 16:02 GMT

>.. 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.

>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

Reply to this Message

Pete_UK - 07 Feb 2008 16:06 GMT

You might find this article to be useful:

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

Hope this helps.

Pete

On Feb 6, 5:00 pm, J.Bennett <JBenn...@discussions.microsoft.com>
wrote:

> 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

Reply to this Message