Lookup Between Two Workbooks

[nac1987]

Hi there,
Hope someone can help me on this, I'm usually astounded by the skill of you guys!

What I need to do is...

Go into "Worksheet B", look at cell A1,
Find that number in "Worksheet A" then progressively fill up the pale blue cells back in "Worksheet B" with any matches.

Any help greatly appreciated.

[NBVC]

With both workbooks opened, go to Workbook A and in a new column, say column Q enter formula:

Please Login or Register  to view this content.

in Q2 and copy down

Then in R2 enter formula:

Please Login or Register  to view this content.

then in Workbook B, in A3 enter formula:

Please Login or Register  to view this content.

copied down and across the columns

NOTE: You will need to adjust the range Sheet1!G:G in the other columns to coincide with the columns you want to point to in WorkbookA... example, in B3 you would need to reference D:D:

Please Login or Register  to view this content.

You can then close Workbook A if desired.

[nac1987]

I can almost get that working!
Thanks so much!
There is another slight snag though...

If I now have two (or more) worksheets open in "WorkbookB" that I would like to update in a similar way, how do I tackle that one?

(see attached)

THANKS! again :D

[NBVC]

Ok, try this amendment.

In that helper column, Q in Workbook A, change formula in Q2 to:

Please Login or Register  to view this content.

and copy down.

Delete formula in R2.

Now in your WorkbookB.

Select both sheets... to do this, right click on any sheet tab, and then Select all sheets (if you have sheets you do not want to affect), then instead, select first sheet, hold SHIFT key down and select last sheet you want to affect.

Then in A2 (or a free cell outside the table), enter formula:

Please Login or Register  to view this content.

where A1:A1000 covers more than all rows in your WorkbookA database.

in A3, now, enter formula:

Please Login or Register  to view this content.

and copy down and across.

Again adjust the G:G column, if necessary to get right column data.

After that, go to sheettab and select to ungroup sheets.

[nac1987]

I'm really greatful for you helping me out by the way!

Two quick questions.
The second formula adds up the total amount of references found in column Q, but then how (or why) does that need to be on the spreadsheet? -Do I include that cell's value somwhere else later?

I've followed the 'evaluate formula' bit and the first part of the long, third, IF-based formula, and the first argument equates to 1. So it works out IF 1 is > than 0, display nothing. So it's always displaying nothing?

I should mention I've just literally copied and pasted your formulas. I've not adjusted anything of real significance.