VLOOKUP in Excel

VLOOKUP in Excel

This function scans down the row headings at the side of a table to find a specified item.                                                        

When the item is found, it then scans across to pick a cell entry.       

Microsoft Excel Function

=VLOOKUP(ItemToFind,RangeToLookIn,ColumnToPickFrom,SortedOrUnsorted)                                                                        

The ItemToFind is a single item specified by the user.                                                                        

The RangeToLookIn is the range of data with the row headings at the left hand side.                                                                        

The ColumnToPickFrom is how far across the table the function should look to pick from.                                                                            

The Sorted/Unsorted is whether the column headings are sorted. TRUE for yes, FALSE for no.

                                                                                               

Formatting

No special formatting is needed.                                                       

Content Data

Jan	15	25	35	45	55
Feb	50	60	70	80	90
Mar	72	98	30	54	77
			Type a month to look for :	Feb
			Which column needs to be picked out :	4
			The result is :	70
				=VLOOKUP(G11,C6:H8,G12,FALSE)