I am looking to see if someone can help me with a formula string that
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 data
sheet) cell c21

if (raw data sheet) cell c4 = (cost info sheet) cell a2 *_and_* if (raw
data sheet) cell d4 = (cost info sheet) cell c2 _*then*_ (cost info
sheet) cell f2 _*if_not_then*_ if (raw data sheet) cell c4 = (cost info
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 data
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 the
cells.

=AK30='C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Cost Info'!$B$4 (VLOOKUP('C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Raw
Data'!BA30,'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Cost Info'!$F$4:$J$9,5,FALSE)) AK30='C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$D$4
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Raw Data'!BA30,'C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost
Info'!$F$4:$J$9,5,FALSE)) AK30='C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$11
(VLOOKUP('C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce
Allocation.xls]Raw Data'!BA30,'C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost
Info'!$F$11:$J$16,5,FALSE)) AK30='C:\Documents and
Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Cost Info'!$B$18
'C:\Documents and Settings\CDRYDEN\Desktop\oce\[Oce Allocation.xls]Raw
Data'!BA30


--
tiggatattoo
------------------------------------------------------------------------
tiggatattoo's Profile: http://www.excelforum.com/member.php...o&userid=35104
View this thread: http://www.excelforum.com/showthread...hreadid=549978