formula translation help, please.

[kins]

hi,


please could someone simplfy the below formula. i think i get the lookup part but i'm a little lost with the beginning.

=IF(ROWS(B$5:B5)<=COUNTIF(Lists!B:B,'Gender Profile'!B$5),VLOOKUP('Gender Profile'!B$5&ROWS(B$5:B5),Lists!A:C,3,0),"")
thanks in advance,

kins

 

[kins]

bump

 

[VBACO]

Basically,
Rows(B$5:B5) is going to be equal to 1 because you are only reffering to 1 cell

CountIF is going to count the number of values in col B that match B5 on gender profile

If 1 is less then or equal to the number of values in Col B that Match B5 on gender profile it will perform the Vlookup for the corresponding value. If it is false then it will be blank.

Not sure that really helps.

 

[kins]

thanks vbaco. not sure i get it, but i'll try and get my head round what you've posted.

i may get back to you