VLOOKUP
What is Vlookup? It’s a formula in Excel that searches a list for a value, and returns a corresponding value.
If you need help to understand VLookup, or you want to see some new tricks to make it do things you didn’t think possible, then check out this list of our best VLookup tutorials.
VLOOKUP – Sorted List Explained
VLOOKUP with Dynamic Column Reference
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
{ 20 comments… read them below or add one }
I have to columns with different Column Names but the data in 2 columns are same .
Ex Col1 has 182 row information and Col2 has 208 row information.
Comparision needed
Col1=Col2
Col1!=Col2
Col2!=Col1
Hi Pavan,
I’m sorry I don’t understand your question. Can you please send me an example Excel file via the help desk.
Thanks,
Mynda.
Dear Madam/Sir,
I want to learn Vlookup. can you provide me the details how can i learn any cd or demo is there.
pls do the needful
thanks.
Hi Supriya,
There are several links on this page to VLOOKUP tutorials. Our training is all online. If you want to take a video course you can find out more and sign up here.
Kind regards,
Mynda.
Hi,
It’s really very good link and provide the perfection in learning.
Thank you very much….
You’re welcome, Prasad
Hello Mynda,
your approach is just wonderful.
Cheers, Samsino
Can you please show me how to calculate percentage where lets say i have several material stored on shelves but would like to caculate in percentage how mush spaced is used and how many unused.
Hi Hendrik,
Space used / total space = % space used
space unused / total space = % space unused
Kind regards,
Mynda.
I need to get a percenile from a non numerical list. Example: Out of 50 entries showing facility in column F, what percentage is SJMC. (all other entries are various facilities.)
To add to my dilema, I have to then break it down by month and yearly quarters.
HELP!!!!!
Hi Pam,
Use Tables for better result. You can simply highlight your data and Go to Insert, Click Tables.
Now let’s Just assume that your dates are in column E and facilities in column F. Note: I have excluded the headers
from the count.
You may use a formula like these:
All items
Monthly
Yearly
The difference between the yearly and monthly formula is merely the parameter dates.
More on Tables, Countifs
Cheers,
CarloE
I keep getting N/A in my V look what could be the reasons. I checked and my cells are all the same no apostrpphy or text
Hi Sabiha,
You get an N/A error if the value you are looking up doesn’t exist in the range you are looking up.
Kind regards,
Mynda.
Dear Sir/Madam,
I am very much interested to know to learn vlookup formulas so please provide the same.
Hi Dattatreya,
You can find a list of our VLOOKUP tutorials on this page. Simply click on the links above to view each tutorial.
Kind regards,
Mynda.
How to folding time in excel example 7:30 + 25:25 + 13:27
Hi Olafur,
Put each value in it’s own cell and then SUM them. Format the cells with custom number format [h]:mm to ensure the total displays correctly.
Kind regards,
Mynda.
I want to learn Vlookup. can you provide me the details how can i learn any cd or demo is there.
pls do the needful
thanks.
Hi Asha,
You can learn VLOOKUP from the links on this page or you can join our Premium training and get access to the video tutorials.
Unfortunately we don’t send CD’s of our training.
Kind regards,
Mynda.