98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLook up
VLook up
Resolved · Medium Priority · Version 2007
Fri 16 Apr 2010, 13:53Delegate Theresa said...
Theresa has attended:
Excel Advanced course
VLook up
I am trying to work with a formular set up by a colleague no longer with the company and need to use it in my work.
Formular does relate to other columns but can you kinldy interpret it for me so I can understand better where the values are coming from.
IF(VLOOKUP(H15,$E$2:$G$10,2,0)=0,VLOOKUP(H15,$E$2:$G$10,3,0),VLOOKUP(H15,$E$2:$G$10,2,0)).
Many thanks,
Theresa
Fri 16 Apr 2010, 14:26Trainer Anthony said...
RE: VLook up
Hi [...], thanks for your query. Might be best to separate out the individual arguments forming the IF statement:
IF(VLOOKUP(H15,$E$2:$G$10,2,0)=0,
...this is the initial test. It's taking the value from H15 and checking whether that value in column index number 2 of the table array $E$2:$G$10 is set to zero.....
VLOOKUP(H15,$E$2:$G$10,3,0),
...if it is 0, it returns the value from column index number 3
VLOOKUP(H15,$E$2:$G$10,2,0)).
...if H15 doesn't have 0 in it, it brings back the value from column index number 2.
Hope this helps,
Anthony
Fri 23 Apr 2010: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcut keys to move between sheetsInstead of clicking on a sheet tab to view a sheet, use the following keyboard shortcuts to move between sheets in the same file: |
