Matching with respect to another column?

[Doug]

I have a table in worksheet A, and imported data that is refreshed every half
hour in worksheet B.
I would like to update the data in worksheet A column AB with respect to the
symbols in column P. The data will be pulled from the import data in
worksheet B.
The columns are the same in both worksheet A, and worksheet B to make it
easier.
How can I do this?

 

[joel]

There is a VBA help topic

Using Events with the QueryTable Object


You can use this event to copy the results of the query from sheet B t
sheet A. Only copy the items that you need updated. I can help wit
the code if needed

 

[Sam Wilson]

Hi,

There are many ways...

1. VLOOKUP - put this in sheet1 column AB2 and drag down:

=VLOOKUP(P2,Sheet2!P:AB,13,false)

2. SUMIF (if you want to add sheet2, column P figures together like a summary)

= SUMIF(Sheet2!P,P2,Sheet2!AB:AB)

there are other ways, those two are the easiest.

Sam

 

[joel]

Sam : Since this is the results of a query the number of items returne
could be different each time and a single lookup may not be sufficien
to perform the request

 

[Sam Wilson]

Hi Joel,

Yes, I know that - referring to Doug's other post ("macro on a timer") the
query results are stock codes & prices. I've made an assumption that there
will be a 1-1 correspondence.

Sam

 

[Doug]

That works great
--
Thank you!

Hi,

There are many ways...

1. VLOOKUP - put this in sheet1 column AB2 and drag down:

=VLOOKUP(P2,Sheet2!P:AB,13,false)

2. SUMIF (if you want to add sheet2, column P figures together like a summary)

= SUMIF(Sheet2!P,P2,Sheet2!AB:AB)

there are other ways, those two are the easiest.

Sam