Excel Code Logic

choyaa

Hi,


I had some trouble yesterday with Excel coding and I received various amounts of help on here. After much trial and error I finally got the code to work, however it doesn't make complete sense. Can someone explain the logic to the following code please?


=IF(RIGHT('tab2'!G2,4)="2016",VLOOKUP(A30,'tab2'!A:IY,MATCH($P$29,'tab2'!$1:$1,0),0),VLOOKUP(A30,'tab2'!A:IY,MATCH(tab1!$P$28,'tab2'!$1:$1,0),0))

bengalknights

It says if the right 4 characters on tab2 are equal to 2016 then run a vlookup and match it to p29 tab2 and if not match to p28

bod1467

And why did you need a NEW thread about the exact same thing? (How many threads is this now about the same "project"?)

All the poster above has done is give the same basic explanation that I gave you in the other thread. (The VLOOKUP/MATCH formula was explained to you in your first thread).

Cotta

Can I ask why the second ",0)" is used after each VLookup? You already used this once within the initial lookup.

bod1467

VLOOKUP has 4 parameters ... Search Term, Source Array, Column Number, True/False

The ,0) is the True/False parameter ... 0 = FALSE

The same VLOOKUP formula is needed in each part of the IF command, one to return P29 match, and the other to return P28 match.

Of course there may be a more elegant way of achieving what the OP is seeking - feel free to advise on this.