Excel Lookup Function 2

[bnsSteve]

Hi There,

I'm trying to create a formula that will look at a cell value then run that value against a list and return the description of the corresponding value. I think this has to do with a look up function.

Ex:
My main worksheet is sheet 1, and I would like the column P to take the value in Column O and if that value is equal to one of the values in 'Sheet2 column A' then return the corresponding description in 'Sheet2 column B'

In Sheet1:
O2 = 2, then,
P2 would return Mortgage PYT because of the following list found in sheet2

In Sheet2
COL A1 = Code - COL B2 =Description
1 - LOAN PAYMENT
2 - MORTGAGE PYT
3 - TO COVER OVERDRAFT
4 - CREDIT CARD/LOC PYT

Hope this is clear.

Thanks.


Running Crystal 11 - 14.0.2.364

 

[SkipVought]

hi,
[tt]
P2: =vlookup(O2,Sheet2!A:B,2,false)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[bnsSteve]

Hi Skip,

Thank you for the quick response, worked great!



Running Crystal 11 - 14.0.2.364

 

[bnsSteve]

Hi Skip,

Wondering if you could help with this formatting situation as well.

If I have a whole number value, is there a way to format it so the last two digits are the cents?

ie., 1614500, I need this to read as $16,145.00 and not $1,614,500.00. Also, the number value can range from 1 digit to say 10 digits in length, they won't all be in the 10's of thousands.

Thanks again,

Running Crystal 11 - 14.0.2.364

 

[Andrzejek]

Can you just divide the number by 100?

Have fun.

---- Andy

 

[bnsSteve]

OMG...thanks Andy, I'll just delete this post now lol.

Running Crystal 11 - 14.0.2.364