T
tiggatattoo
I am looking to see if someone can help me with a formula string tha
may work. I have one but it doesn't seem to work.
This is what I am looking to do--- the formula starts in (raw dat
sheet) cell c21
if (raw data sheet) cell c4 = (cost info sheet) cell a2 *_and_* if (ra
data sheet) cell d4 = (cost info sheet) cell c2 _*then*_ (cost inf
sheet) cell f2 _*if_not_then*_ if (raw data sheet) cell c4 = (cost inf
sheet) cell a3 *_and_* if (raw data sheet) cell d4 = (cost info sheet
cell c3 *_then_* (cost info sheet) cell f3 _*if_not_then*_ if (raw dat
sheet) cell c4 = (cost info sheet) cell a4 *_and_* if (raw data sheet
cell d4 = (cost info sheet) cell c4 _*then_*_(cost info sheet) cell f4
*_the_answer_to_be_placed_in_(raw_data_sheet)_cell_c21_*
help! Here is the original formula, but it is not working in all th
cells.
=AK30='C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Cost Info'!$B$4 (VLOOKUP('C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Ra
Data'!BA30,'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Cost Info'!$F$4:$J$9,5,FALSE)) AK30='C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$D$
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Raw Data'!BA30,'C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cos
Info'!$F$4:$J$9,5,FALSE)) AK30='C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$1
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Raw Data'!BA30,'C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cos
Info'!$F$11:$J$16,5,FALSE)) AK30='C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$1
'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Ra
Data'!BA3
may work. I have one but it doesn't seem to work.
This is what I am looking to do--- the formula starts in (raw dat
sheet) cell c21
if (raw data sheet) cell c4 = (cost info sheet) cell a2 *_and_* if (ra
data sheet) cell d4 = (cost info sheet) cell c2 _*then*_ (cost inf
sheet) cell f2 _*if_not_then*_ if (raw data sheet) cell c4 = (cost inf
sheet) cell a3 *_and_* if (raw data sheet) cell d4 = (cost info sheet
cell c3 *_then_* (cost info sheet) cell f3 _*if_not_then*_ if (raw dat
sheet) cell c4 = (cost info sheet) cell a4 *_and_* if (raw data sheet
cell d4 = (cost info sheet) cell c4 _*then_*_(cost info sheet) cell f4
*_the_answer_to_be_placed_in_(raw_data_sheet)_cell_c21_*
help! Here is the original formula, but it is not working in all th
cells.
=AK30='C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Cost Info'!$B$4 (VLOOKUP('C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Ra
Data'!BA30,'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Cost Info'!$F$4:$J$9,5,FALSE)) AK30='C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$D$
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Raw Data'!BA30,'C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cos
Info'!$F$4:$J$9,5,FALSE)) AK30='C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$1
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oc
Allocation.xls]Raw Data'!BA30,'C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cos
Info'!$F$11:$J$16,5,FALSE)) AK30='C:\Documents an
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$1
'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Ra
Data'!BA3