Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLook up
|
|
|
The UK's most regular 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. |
VLook up
Resolved · Medium Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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.
|