Using multiple Lookup Functions

G

Gaura215

Board Regular
Joined
Feb 2, 2011
Messages
97
Respected Excel Gurus

I spent nearly 2 hours daily on updating a report from a dump, which I download from a website. I am wonderin if this can be automated using some formulaes or Macro. Please help me out.

I can share the 2 spreadsheets which I need to compare. Please advice, if someone can help me with this. Its difficult to explain it in words without sharing the spreadsheets. So I will share the spreadsheet with whatever explanation I can give.

Help please :)
 
Sort by date Sort by votes
BlueHornet

Your second one works perfectly fine for me. Thanks a lot.

Peter, thanks to you too to make me learn important tips to post my problems over here.

Thanks guys :)
 
Upvote 0

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
You must log in or register to reply here.

Similar threads

A
  • Question
median not working
2
Replies
16
Views
385
Peter_SSs
Peter_SSs
B
  • Question
VBA/Formula to only run lookup if a cells value is a match
Replies
0
Views
389
Benjo83
B
T
  • Question
Pop Up Message if specific cells are greater than other specific cells
Replies
5
Views
584
tabs1063
T
I
  • Question
macros blocked but all security settings appear to be correct
Replies
2
Views
190
IMPOSSIBLE7925
I
C
  • Solved
Re-arranging and Sorting Data using a VBA Macro
2
Replies
10
Views
123
Akuini
Akuini

Forum statistics

Threads
1,216,579
Messages
6,131,531
Members
449,654
Latest member
andz

Share this page

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