Hi, I have attched the table, basically I wish to do the subtraction between column H and column B, Column I with Column C, to check if both absolute value are less than 1000, if so I wish to assign the corresponded value from column F to new a column.
e.g IF H2-any row from column B, I2-any row from column C, both less than 1000, find the row number in B/C, and assign the F value to a new column. If find multiple rows, do the average of corresponded F column value.
Note: Column H and I has more rows than Column B and C
I tried IF Vlookup but filed.
Many thanks for your help.
Bookmarks