Good evening,

I have been watching these posts and picked up a lot of useful tips from this community. I recently got a promotion on April 1st and I am trying to leverage technology to help automate some tasks for my guys to get them out of work earlier.

I have this organizational loading sheet and I am trying to have it return certain information about an order, based off of the shipment number.

The formula I am trying to figure out would be in cell E13.

I want the formula to look at a range of cells (E4-E10). If there is nothing there, I want it to return a value that equals a cell in another tab of the same worksheet called ORDERS!H4.

If it finds something in E4 and not E5, I want it to return the value in cell ORDERS!H5. If it finds something in E4 and E5, I want it to return the value in cell ORDERS!H6...so on and so forth.

I am probably missing something really simple, just frustrated because the project was going well and then I got stuck on this part.

Thanks!