twowaylookup

  1. S

    Two way lookup with if/match return

    Hi All, Need help, I am struggling to find the solution. Below is my details, A B C D E F G H I J 1 Name Date 1 2 3 4 5 6 7 8 2 Day Fri Sat Sun Mon Tue Wed Thu Fri 3 Mr. A B B B A A O B A 4 Mr. B A A O B B L O B 5 Mr. C L O L L L B A A...
  2. E

    VBA Transform Data into Excel Table(No Repetitive Header and Future Expandable)

    Dear All, I'm New to VBA excel and would like to write a Code whereby: 1) Convert raw data(another Workbook)(repetitive "supplier" and "type", f) to Non-repetitive table. 2) Result Table with autosum(New Workbook) as below: 3) The Result table will be expanded with Raw Data future key in...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top