I have 2 sheet in excel 2010s: In the 1st Sheet I have all the data and a 2nd sheet where based on the ID's entered(TP) on column A-Sheet2
the formula returns rows from Sheet1.
Formula used : =IF(COUNTIF(Sheet2!$A:$A,Sheet1!$E1),IF(ISBLANK(Sheet1!E1),"",Sheet1!E1),"")
As it can be seen, in column A from Sheet2 the ID's entered are in a specific order (they are copied from another excel file). Is there a formula that arranges the findings from Sheet2 (column F,G,H) in the same line with Id's from column A-Sheet2?