How to become an Excel master!

[MrM90]

Hi everyone,

I am new to this forum. I really want to learn everything on Excel and become a master at it. Can anyone suggest any good guides on Formulas/Macros?

Also I wonder if anyone can help me figure out the correct Formula I need.

I have a set of data which looks like:

Data A)

[TABLE="width: 250"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Limit[/TD]
[TD]Grade[/TD]
[/TR]
[TR]
[TD]Dave[/TD]
[TD]100k[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]80k[/TD]
[TD]B[/TD]
[/TR]
</tbody>[/TABLE]


I then have another set of data:

Data B)


[TABLE="width: 250"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Balance[/TD]
[TD]Days[/TD]
[/TR]
[TR]
[TD]Dave[/TD]
[TD]90k[/TD]
[TD]85[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]65k[/TD]
[TD]65[/TD]
[/TR]
</tbody>[/TABLE]


So I will have data A in a separate tab saved at all times which will change only every 3 months.

Data B will be picked up monthly.

So basically I need a formula I can use so when I put data B in, it picks up the matches from data A and copies it. So it will eventually look like:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Balance[/TD]
[TD]Days[/TD]
[TD]Limit[/TD]
[TD]Grade[/TD]
[/TR]
[TR]
[TD]Dave[/TD]
[TD]90k[/TD]
[TD]85[/TD]
[TD]100k[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]Bob[/TD]
[TD]65k[/TD]
[TD]65[/TD]
[TD]65k[/TD]
[TD]B[/TD]
[/TR]
</tbody>[/TABLE]


I have been trying to look online for a formula and it comes up with "lookup" formula but I do not understand it. Are there any wizzes that can help please?

Thanks

 

[AkaTrouble]

here is my addition to Great list from hiker95

this is my must have favourite for non VBA solutions

https://www.youtube.com/user/ExcelIsFun

 

[MARK858]

here is my addition to Great list from hiker95

this is my must have favourite for non VBA solutions

https://www.youtube.com/user/ExcelIsFun

I think you will find it is already on Hiker95's list

 

[AkaTrouble]

I think you will find it is already on Hiker95's list

opps i did check must off got blinded while scanning the list it seems

my bad well done hiker 95 for complete list i have updated my copy as used your list in the past many times

 

[hiker95]

AkaTrouble, MARK858, MrM90,

Thanks for the feedback.

Glad I could help.