How to use Vlookups?

I have used excel for years. I see that a lot of people are just scratching the surface and do not know all the functions.

For a business, you will have a couple of vendors you deal with and you will need to pay them and manage POs.

Below is just a starter and encourage people to have a “Do it Yourself” attitude. See the below to see how I deconstruct a problem and provide a solution that is readable.

Reference:

=VLOOKUP(F5,C:D,2,0)

=”For “&VLOOKUP(F10,B:C,2,0)&” the price is “&”$”&VLOOKUP(F10,B:D,3,0)&”.”

For super easy plug-ins you can download the below plug-in. Only if you want to save time and effort.

CLICK HERE for DOSE PLUG-IN on EXCEL

Create your website at WordPress.com
Get started
%d bloggers like this: