- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.programming
- 2015 July
- Combining VLOOKUP and IF formulas

Subject: | Combining VLOOKUP and IF formulas |

Posted by: | rtour957 (rtour957.fdb67…@excelbanter.com) |

Date: | Thu, 2 Jul 2015 |

I have services in one column and rates in another.

I have a VLOOKUP formula =IF(A1>0,VLOOKUP(A1,brates,2,)," ") that works

just fine and whenever a service in A1 is chosen the rate is entered

based on ‘brates’ table.

One of the services however is training (code CT) and the third column

is for the number of training hours so rate depends on ## of training

hours.

I came up with the another IF formula =IF(A1="CT",N1*10,) that

calculates total rate based on number of training hours times the base

rate only when A1=CT . Both formulas work fine separately but I have

difficult time combining it in one nested IF formula so bot IF

conditions are taken into consideration. No matter what the correct rate

is not calculated. What am I doing wrong?

--

rtour957

- Re: Combining VLOOKUP and IF formulas posted by isabelle on Thu, 02 Jul 2015