Help needed If or Vlookup Fucntion

[kashh83]

Hi,
I am after a quick solution which let me take values from three or four different cells and show as one.
I am trying to rate some companies in a financial model and with help of If functions I have rated those companies in different variable getting the result such as:

A B B
A A A
A B C

I am after a solution which let me have this result in one column i.e. =IF(AND(A1="A",B1="A",C1="A"),"AAA") I know I can use this function for one variable but there are lots of different variable, does anyone know a way around it. so in simple terms i need a formula which picks values/text from three cells and merge all that information in one cell from the above example it take A B B and make ABB hence the rating of that company would be ABB.

Thank you in advance.

Kash

[hafizimran]

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[kashh83]

Okay this was simple, thank you so much for quick response.
Kash