Is This Possible?

[pariash]

Hello All,

I just joined this board and from browsing, it looks as if I found the right place to get some assistance.

Let's say I have a sales order report that lists among other fields, the department # of the customer. For example, if the department # on the report is 555 is it possible to set up a formula or function to look at this value in a different sheet and have the description of the dept id filled in a different cell?

Thanks in advance

 

[T. Valko]

Hello All,

I just joined this board and from browsing, it looks as if I found the right place to get some assistance.

Let's say I have a sales order report that lists among other fields, the department # of the customer. For example, if the department # on the report is 555 is it possible to set up a formula or function to look at this value in a different sheet and have the description of the dept id filled in a different cell?

Thanks in advance

See this...

http://contextures.com/xlFunctions02.html

 

[wigi]

Welcome on board.

You need the VLOOKUP function in Excel.

 

[pariash]

See this...

http://contextures.com/xlFunctions02.html

Thank you. Looks like the site is down but I will try again. I appreciate the quick response.

 

[wigi]

Looks like the site is down but I will try again.

Not for me, just tested it.

 

[pariash]

Not for me, just tested it.

Looks like a block from my work servers. I will try again a little later...

Thank you again