More than 7 IFs?

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

Hi! Thanks to an earlier post concerning dropdown menus
and referancing the data therein, I was able to create a
If Statements that placed the correct information in the
correct cells based on the menu selection. (If A1=1,
Company Address, "") Which will spit out the Address for
teh Company selected in teh drop down box referenced to
A1. However, I have more than 7 companies and other such
data. What other fomula can I use instead of the nested IF
statements? if I was used numbers, I can use OR, but I'm
not... Thanks for the help, and I hope I explained
everything accurately.
sam
 
Thanks!! The formula =VLOOKUP(C5, To!A1:J100,2, FALSE)
worked just fine!! For those unfamiliar w/ the VLOOKUP
formula here's the breadown:
c5 = the datavaildation menu
To!A1:J100 = the range of information in the sheet with
the company information
2 = the column number
false = returns the exact match

Thanks again.
-sam
 
Back
Top