Forum Discussion

Jigyasa's avatar
Jigyasa
Copper Contributor
Feb 14, 2023

Is it best practice to add helper columns or is there a better way to vlookup?

I need to lookup pay rate exceptions from a separate sheet. On the separate sheet, I have four tables: 1. Client names, days of the week, and job type 2. Second table with days of the week, job typ...
excel
Formulas and Functions
training
Harun24HR's avatar
Harun24HR
Bronze Contributor
Feb 14, 2023
What is your Excel version? Using Microsoft-365 dynamic formulas this can be simplified. Share a sample workbook and show your desired output.
Jigyasa's avatar
Jigyasa
Copper Contributor
Feb 14, 2023

Harun24HR Hi I am on Excel 365.

I've attached a demo file. The exception sheet is a separate sheet in my actual case and there is a macro that runs to create sheet 3. I am wondering if I am following the best practice method to achieve this. 

Resources