Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel software training london - VlookupvsHlookup

excel software training london - VlookupvsHlookup

ResolvedVersion Standard

Fri 1 Dec 2006, 16:54 Delegate Lebogang said...

Lebogang has attended:
Excel Advanced course

VlookupvsHlookup

Hi

If I were to replace V with Hlookup do I need to change my table array? or will it still give me the same question.

CAn you refer me to websires were I can find complex workbooks to practice my formulas on?

Thanks,

Mon 4 Dec 2006, 09:37 Trainer Richard said...

RE: VlookupvsHlookup

Hlookup would look for value you have specified in the first ROW in your array. So depending on the result you are looking for, you may want to modify your range.

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel software training london - VlookupvsHlookup

VlookupvsHlookup

RE: VlookupvsHlookup

Excel articles

Excel tip:

Bracketed negative numbers