Formulas within workbook but seperate sheets.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Formula - Count Dates from another Sheet 8
Dependent drop down dynamic range formula, off sheet. 7
Scrabble Value calculation for Welsh words 0
Seperate worksheets 1
Need VLOOKUP to Work Two Ways 0
Totalling data from several workbooks to a Summary Sheet 1
Indexing Sheets in Referenced Workbook within formula 1
How to copy & paste a worksheet but change 1 bit of the formula? 1

Back
Top