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)

Name	Limit	Grade
Dave	100k	A
Bob	80k	B

<tbody>
</tbody>

I then have another set of data:

Data B)

Name	Balance	Days
Dave	90k	85
Bob	65k	65

<tbody>
</tbody>

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:

Name	Balance	Days	Limit	Grade
Dave	90k	85	100k	A
Bob	65k	65	65k	B

<tbody>
</tbody>

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.