If you are just looking to match, you can use the LOOKUP function on
Column D. For example
=Lookup(D1,{"travel","air/fares","tolls"},{200,400,50})
- Madhu
On Jun 15, 7:13*pm, Len wrote:
Hi,

How to set a nested IF function to check column D for one or more
specific texts ,if matches it returns the corresponding value from
column J and go on the next row until it reaches the furnishing line
for example,
* * * * * Column D * * * Column J * * * * * * *Column L

1) …travel… * * * * * * * * * * * 200.00
IF(ISNUMBER(FIND("travel",$D1)),$J1,"") = 200.00
2) …air/fares * * * * * * * * * * * 400.00
IF(ISNUMBER(FIND("travel",$D1)),$J1,"") = blank
3) …tolls… * * * * * * * * * * * * * 50.00
IF(ISNUMBER(FIND("tolls",$D2)),$J2,"") = 50.00
4) …B’trips…travel… * * * * *124.00 * * * * * * * Nested IF
formula ??? *= 124.00
5) …B’trips…travel… tolls.. *75.00 * * * * * Nested IF formula ??? *=
75.00

For item 4), Nested IF formula for one or more specific texts ( ie
B'trip or travel )
For item 5), Nested IF formula for one or more specific texts ( ie
B'trip or travel or tolls )

Is it possible to set the above function such as like or contain to
check for one or more specific text from that row ?

Please help, many thanks

Regards
Len