Link Data Based On Cell Reference

**rizmomin** · 07-23-2009, 10:51 PM

Please see attached sheet...

Sheet1 has monthly data for each client.
Depending on the month I enter in cell c2 of Sheet2, I need the formula to copy the data from sheet1 into sheet2,column C as currently shown in Sheet2.

Please help....

Thank you,

Riz

**ConneXionLost** · 07-23-2009, 10:59 PM

Hi rizmomin,

Your Sheet2 has multiple entries in column B with the same name (and you don't provide a unique compound key identifier as in Sheet1 column A). So how would you like to determine which record to bring to Sheet2?

Cheers,

**rizmomin** · 07-23-2009, 11:11 PM

Opps sorry...
Sheet 2 can be like this:

Feb-09 ETMC Athens 232484 (Combined value of ETMC Athens for Feb-09
Feb-09 ETMC Fairfield 41399 (Combined value of ETMC F'Field for Feb-09)

etc...

OR i have just change sheet2 ...added column A with value so to distinguish the value

Let me know if you have any further question.

Thank you,

Riz