Vlookup returning data

[GrandadUK]

I have a spreadsheet of acronyms Column A is the acronym and column B the definition.
I use a lookup table so that if you put the acronym in A4 it returns the definition in B4, however, the list now contains a lot of acronyms that have more than one meaning.
OK I get the first defintion reached in the vlookup returned to B4 but I need to return duplicates i.e 2nd definition into C4, 3rd into D4 etc.

Any ideas?

 

[SkipVought]

Hi,

How do you want the additional definitions returned, seeing that a FUNCTION returns only one value?

Please be CLEAR, CONCISE and COMPLETE.

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[Gavona]

I am SURE Skip or others can help with something more elegant but quick and dirty....
You could achieve something similar very easily with a pivot table. Acronym as a page field, definition as a column or row field. Count of definition as a data field (which you could congigure to be white and thus invisible...



Gavin

 

[yogia]

Hi GrandadUK:

Let me see if I have understood you correctly ...

The acronym database starts from row 6 down, and I have assumed upto 5 possible definitions -- you can adjust that to suit your needs.

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com