excel consulting - V lock up

Hi Zsanett

Thanks for your question.

You can do a vlookup on a list (data stored in a series of columns) as long as the lookup value is in the leftmost column of your list you should be able to get Excel to display data from in the same row as a particular lookup value.

For more information, use Excel Help to find vlookup, or use the insert function button to the left of the formula bar on your screen, locate the vlookup function and click the Help on this function link.

Amanda