Iffunction questions pulling values from other sheets +return value from partial data

  • Thread starter Thread starter HoundofCullin
  • Start date Start date
H

HoundofCullin

I have been struggling with the IF Function for a while, what I a
trying to accomplish is this:

Let's say the data in cell A1 depends on part of the data in cell B1.
need the function to bring up a value in A1 (for this example we'll us
Nelson Rains) ONLY IF the first two letters in Cell B1 are NR.

So basically if I enter "NR430" in cell "B1" then cell A1 will displa
"Nelson Rains".

Can this be Done?

+--------------------------------------------------+

Another matter (albeit less pressing) I would like help on is whethe
or not an IF Function can pull data from another sheet within the sam
workbook.

Let's use the above example:

I want Cell A1 on the sheet named "First" to display "Nelson Rains" i
cell B1 in the sheet titled "Second" starts with the letters NR.

Essentially:
When I type "NR430" into cell B1 on "Second", then, Cell A1 on "First
will display "Nelson Rains"

Or assuming you can't post data based on the first two letters tha
let's assume that the ENTIRE entry (NR430) into B1 on sheet "second
causes A1 in "First" to display Nelson Rains.


Any suggestions/help would be appreciated,

Jos
 
Back
Top