Excel formula help
Posted on 2011-09-02
How do you I say while logic in excel formula.
OR maybe ue array formula to achieve it.
Please have al ook at the attached spreadsheet.
On tab key I have a key and ref.
in Ref column I am using -> IF(ISNA(VLOOKUP(A2,rngRef,2,FALSE)),"",VLOOKUP(A2,rngRef,2,FALSE))
To get ref_src from RANGE -> rngRef on tab KeySrc
basically just mapping the keys and getting the corresponding ref
Please let me know irf its not clear. I am sure you will figure out quikcly by looking at the attached sheet
Now What I am trying to acheive is that
there are two rows/records with same key '123'
and I am trying to get Ref and combination of Ref_src for the same key
in the from Ref_src, Ref_src
so for key = 123
Ref would look like a,b
It would be very helpful if some one could help me out in achieving this