Lookup in other sheets

[JohnExcel222]

Hi there,

• I have a source data: Work Orders (column A)
• At he beginning: Column B and Column C are empty
• 
  
• Column B needs to look up in Sheets “Intern” / “Extern”
• A work order is either “Intern” or “Extern”
• A work order which is neither “Intern” or “Extern” is “new” (to be marked as new in columns B and C)

• Look up tables: Intern / Extern / Costs_known/ Costs_unknown
• The answer to the column B and C in “Work Orders” is always in column A

The marco should work in the active workbook.

Screenshots are uploaded
Thanks in advance

 

[JohnExcel222]

Hi there,

• I have a source data: Work Orders (column A)
• At he beginning: Column B and Column C are empty
• 
  
• Column B needs to look up in Sheets “Intern” / “Extern”
• A work order is either “Intern” or “Extern”
• A work order which is neither “Intern” or “Extern” is “new” (to be marked as new in columns B and C)

• Look up tables: Intern / Extern / Costs_known/ Costs_unknown
• The answer to the column B and C in “Work Orders” is always in column A

The marco should work in the active workbook.

Screenshots are uploaded
Thanks in advanc

 

[JohnExcel222]

• Column C needs to look up in Sheets “Costs_known” / “Costs_unknown”
• The costs types are either “known” or “unknown”
• a work order which is neither “known” or “unknown” is marked as “No costs at all”

 

[JohnExcel222]

Maybe the first step will be to combine the sheets intern and extern together and the costs known/unknown together