Pedro has attended:
Excel Intermediate course
Excel Advanced course
How do look up tables work?
Having problems with the theory behind VLOOKUPS.
Thanks
RE: How do look up tables work?
Hi Pedro
Thank you for your question; and apologies for the delay in response.
The idea behind the VLOOKUP is that you can ask Excel to look for a certain value or piece of text in one column, and then find and display another value/piece of text in the same row but a different column. Basically it saves you from having to look through a column of data for a particular bit of data, then find another piece of data in the same row yourself.
I hope this helps.
Amanda