stringing across duplicate fields

[Jaimee001]

Hello all and a Happy's Fathers Day! Long ago I had received some help (from this group) on stringing across duplicate fields. I use it all the time! Now I have a similar situation. I have duplicate rows based on codes and code descriptors. I know how to do this based on the code but am not able to figure out how to add the descriptors

This is what I can do:

Acct No ~~ Code1~~ Code2

This is what I need

Acct No

code1~~ Code1 Descriptor~~ Code2~~Code2 Descriptor

All of my formulas are included in my example

[pre]http://speedy.sh/D7jgy/Example-for-adenda-codes-across.xlsx[/pre]


Thank you in advance!!!!

 

[NARAYANK991]

Hi ,


I am not sure I have understood your requirement fully ; however , let me try.


1. For the Code1 Descriptor , the following formula should do the job :


=VLOOKUP(F2,$C$2:$E$11,3,FALSE)


2. For the Code2 Descriptor , the following formula should do the job :


=VLOOKUP(F3&"2",$B$2:$E$11,4,FALSE)


Narayan