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
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
