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

You have information on sheet2 that would be useful if it were in sheet1 e.g. Agent Name (see Sheet2 A8), also Origin (Sheet2 B4) how does this information get input on this sheet? I'm assuming manually!? So why not have this information also on Sheet1 maybe in columns A and B and then you could use Vlookup or Index & Match etc. based on this criteria. I am a little confused??

Ok if we keep it in one sheet but still can you help with the formula

Two sheets are not the problem but the missing information that I mentioned before is