microsoft excel training courses london - HLook up formulas

Resolved · Low Priority · Version Standard

Wed 4 Apr 2007, 13:43 Delegate Kamila said...

Kamila has attended:
Excel Advanced course

HLook up formulas

could you please let me know how it works? Thanks

Wed 4 Apr 2007, 15:54 Trainer Tracy said...

RE: HLook up formulas

Hi Kamila,

The H lookup or horizontal lookup searches for a value in the top row of a table, and then returns a value in the same column from a row you specify in the table. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows.

For example if you used

=HLOOKUP("Training",A1:D4,4) goes across the first row and looks up the word Training, and it returns the value from row 4 that's in the same column. So in effect it goes across and then down.

Hope that helps

Tracy

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips