formulas for search based on multiple criteria in multiple columns

The value in the cell g8 in sheet 2 = sheet 1!g value provided



sheet2!b8 = sheet1!line

sheet2!m4 = sheet1!ctype

sheet2!c8 = sheet1!pod

sheet2!j4 = sheet1!fpod

sheet2!m5 > sheet1!weight st

sheet2!m5 < sheet1!weight ends



similarily for cell sheet2!h8 = sheet1!g value provided



sheet2!b8 = sheet1!line

sheet2!n4 = sheet1!ctype

sheet2!c8 = sheet1!pod

sheet2!j4 = sheet1!fpod

sheet2!n5 > sheet1!weight st

sheet2!n5 < sheet1!weight ends



point to note is that for h8 only sheet 2 ref changes from m column to n column

also where the reference is row 5 / row 4 it does not change however for values in g9 / h9 search reference input changes



please advise