transferring data from a shared workbook

  • Thread starter Thread starter Joey
  • Start date Start date
J

Joey

Hi all

I'm trying to create a spreadsheet that returns data from anothe
shared worksheet used by a number of colleagues.

Is it possible to have a formula which recognises data in the above ro
and then if something is in there the data should go to the following


Eg.

The first row would have a normal IF or Lookup formula.

This is in A2
=IF(A1=a value or data,the lookup data I'm searching,"")

My appologies for not knowing the terminology of what the argument
should be.

If there is an easier way, please let me know.

Many thanks
Joe
 
Joey,

We would really need to know what you mean by

"the lookup data I'm searching"?

Are you trying to lookup data based on the value in A1, or is that just a
trigger?

Post a message with a small sample of your data set, and the logic which you
would want to use to extract the required data from it.

HTH,
Bernie
MS Excel MVP
 
My apologies Bernie

"The lookup data I'm searching" is supposed to describe what I'
looking to transfer into this sheet.
The formula should avoid copying over previously stored data in thes
cells and return data if there is nothing in it already.
My attempts before this only seems to over write previous data.

I've attached a spreadsheet with an example of what I'm trying to do.



Many thanks
Joe

Attachment filename: data transfer test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=58444
 
Back
Top