VLookup or Something Else?

[Guest]

Hello-

I have 2 spreadsheets.

Spreadsheet "A" I have Raw Data with a unique ID code in column A.
I have made a pivot table with this data which is in column D on the Pivot
Table.

Spreadsheet "B" has a TON of stuff in it - including the unique ID in column
Q.

I want to find, match, lookup the ID in column Q and get the data from
column G to put in my pivot table in spreadsheet "A". in column F.

Is this even possible? I could sort Spreadsheet B on the ID column to makeit
ascending, but that is not how it is in the pivot table.

Also, what are the ramifications if the unique ID has multiples in
spreadsheet B?

Thank you so much.

 

[Carim]

Hi,

Try replicate with index() and match() functions ...

As an example : =INDEX(A1:C5,MATCH(12,C1:C5,FALSE),1)

HTH
Cheers
Carim