G
Guest
Hi
I have a sheet with codes which have several components against each code
and on another sheet i have a vlookup formula this just gives me first
component i would like to add something to vlookup to find the 2nd or 3rd
time code appears and its component
my formula so far is
=if(countif(sheet1!c1:c2,a1)>0,vlookup(a1,sheet1!c1:c2,2,false)," ")
this would return baa0001 from following table on sheet1 on next row i would
like to put countif > 1 and return caa0001 but do not now how
sheet1
A B
code component
925001 baa0001
925001 caa0001
925001 daa0001
925002 baa0002
925002 caa0002
sheet2
a1 = 925001
hope this makes sense
Thanks
Tina
I have a sheet with codes which have several components against each code
and on another sheet i have a vlookup formula this just gives me first
component i would like to add something to vlookup to find the 2nd or 3rd
time code appears and its component
my formula so far is
=if(countif(sheet1!c1:c2,a1)>0,vlookup(a1,sheet1!c1:c2,2,false)," ")
this would return baa0001 from following table on sheet1 on next row i would
like to put countif > 1 and return caa0001 but do not now how
sheet1
A B
code component
925001 baa0001
925001 caa0001
925001 daa0001
925002 baa0002
925002 caa0002
sheet2
a1 = 925001
hope this makes sense
Thanks
Tina