Large IF/Lookup

[demon8991]

Basically i have a spreadsheet with a large list of companies (50+) each with it's own acronym which is listed off screen.

Back within the printable area the user types the acronym in and i want the cell above to display the full company name.

Is this possible?

[teylyn]

Hi demon,

you probably need Vlookup or the Index/Match combination. If your off-screen list is organised like this:

Please Login or Register  to view this content.

then you can use

=vlookup(A1,X1:Y50,2,False)

where A1 is the cell where the user types the acronym and X1:Y50 is the table as indicated above.

if the list is the other way round, like

Please Login or Register  to view this content.

you may want to try something like

=index(X1:X50,match(a1,Y1:Y100,0))

Instead of letting the user type the acronym, you can use data validation with the list option so they can only enter values on the list. This will avoid data entry errors and make life a bit easier.

hth

[Jbentley]

Hi,

Yes, this is possible.
I'm assuming you have both the Acronym and the full company name laid out in a table....

Take a look at the attached, might steer you in the right direction

[Jbentley]

Apologies Teylyn, didn't see your post.

[teylyn]

no worries, JB, happens all the time ....
greetings to the big smoke from the 'naki

[demon8991]

Thanks so much!

Massive help!