excel formula - PULL DATA FROM TWO SHEETS -


looking excel formula match data in sheet 1 column (delivery number) data in sheet 2 column b (delivery number), pull data that's in sheet 2 column (po number) new column in sheet 1. there more lines in sheet 2 column b in sheet 1, column a. please help!

if po number numeric can use =sumifs(sheet2!a:a,sheet2!b:b,a2)/countifs(sheet2!b:b,sheet1!a2)


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

datatable - Matlab struct computations -