Hi All,

I need to fetch data related to quantity of products bought.

Workbook 1: Has list of products say from Column A2 cell to A1669. B2 has quantities.

Let's say A15 to A23 has "Apple" and B15 to B23 has a quantity value for it.

Workbook 2: Has "Apple" in Column H again H2 to H10.

How can I look-up the quantity of A15 in B15 from workbook 1 to column G cell G2 in workbook 2, similarly from A16 in B16 to G3...?

Also, the data at time isn't in a chrono order. I don't have another identifier (unique) between the sheets.

The Vlookup I'm using is picking the quantity for B15 only and pasting it all across G2 to G10 in workbook 2

Please suggest...