Need help to filter data from multipule sheets to specific sheet
Hi,
If I didn't misunderstand you you want to compare the ID in sheet3 with the
ID in sheet 2 or 1 and if it exist to bring the data from column B , if so use
=sumproduct(--(a1=sheet2!$A$1:$A$1000),sheet2!$B$1:$B$1000)
if this is not what you are looking for please provide an example mentioning
columns and sheet number
"Khawajaanwar" wrote:
i have a data in sheet1, sheet2 and sheet3. Data in all sheets have unique
id(number). I have to filter data with unique id in sheet3 if the same unique
id exists in sheet1 or sheet2 the data of column B or C incorporated in
sheet3 in specified column of the unique id row.
Sorry friends my english is not good.
|