Formulas within workbook but seperate sheets.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kenmills2 - 13 Feb 2007 05:25 GMT

I am trying to find a formula to state if I inter a v or a d in this field
from a different book then put the # from another field in here. Can someone
help me with this

Reply to this Message

Nandezx - 13 Feb 2007 10:40 GMT

It depends. How are the numbers in the second field organised? If they're
organised in some sort of table that matches each # to a letter/category,
then you can probably use VLOOKUP or HLOOKUP to do so.

> I am trying to find a formula to state if I inter a v or a d in this field
> from a different book then put the # from another field in here. Can someone
> help me with this

Reply to this Message

kenmills2 - 13 Feb 2007 21:31 GMT

I want to be able to put my own text in the second cell. Basically, I am am
trying to organize my spending and have it move to one page to add up in the
proper cell on my total page.

> It depends. How are the numbers in the second field organised? If they're
> organised in some sort of table that matches each # to a letter/category,
[quoted text clipped - 3 lines]
> > from a different book then put the # from another field in here. Can someone
> > help me with this

Reply to this Message