Hi,

Im hoping someone could please help me with a formula that I am struggling with.  I have two sheets in the file.  One file is the main page that is used and the other page has the data. The main page contains 5 columns. 3 of the columns have existing data, column A is a unique number, column B is a ship to number and column C has the weight.  Column D how to ship and column e what code I would like to get this information from a formula in the data tab.  The data tab has 4 columns ship to, weight, how to ship and what code. How to ship is dependent on what the weight is. 

UNIQUE NUMBERSHIP TOWEIGHTHOW TO SHIP

WHAT CODE

4084480P524060  4212822P5240175  

SHIP TOWEIGHTHOW TO SHIPWHAT CODEP5240<=60AIRSPECIAL 1P5240>60 <=250AIRTO BE ADVISEDP5240>250SEAD13456

what combined formula can i use to retrieve this information for me?

​Hi,Im hoping someone could please help me with a formula that I am struggling with.  I have two sheets in the file.  One file is the main page that is used and the other page has the data. The main page contains 5 columns. 3 of the columns have existing data, column A is a unique number, column B is a ship to number and column C has the weight.  Column D how to ship and column e what code I would like to get this information from a formula in the data tab.  The data tab has 4 columns ship to, weight, how to ship and what code. How to ship is dependent on what the weight is. UNIQUE NUMBERSHIP TOWEIGHTHOW TO SHIPWHAT CODE   4084480P524060  4212822P5240175   SHIP TOWEIGHTHOW TO SHIPWHAT CODEP5240<=60AIRSPECIAL 1P5240>60 <=250AIRTO BE ADVISEDP5240>250SEAD13456what combined formula can i use to retrieve this information for me?   Read More

​