floggingmolly
Board Regular
- Joined
- Sep 14, 2019
- Messages
- 167
- Office Version
- 365
- Platform
- Windows
I have a workbook with 2 sheets. On Sheet1 I have in column G a list of Station Numbers. On Sheet 2 I have Station #'s in Column A and Column B, then in E there is a due date. I am trying to figure out a formula that will look for a certain # on sheet 2 in column A and B, then return the date in column E. Not sure if that makes sense. For Example: On Sheet 1 in column G I have station #200. On Sheet 2 that # might be in Column A or B depending on their location, so I need to somehow do a lookup in A and B to find #200, then give me the corresponding date from column E. If anyone could help it would be greatly appreciated. I have been trying for 3 days and can't get it to work.