Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports

# Thread: Nest If And Vlookup Function

1. I agreed to these rules
Join Date
27th April 2007
Posts
11

## Nest If And Vlookup Function

Hi

My formula in I3 is returning the #value error. If F3 = yes, I want \$3.50 put in I3 (this works by itself), then when I changed the formula to add the VLOOKUP to get the rates if F3 is blank I got the error.

Can somebody help me with this please.

Thanks
Tracy

Excel Video Tutorials / Excel Dashboards Reports

2. ## Re: Nest If And Vlookup Function

=IF(F3="YES",3.5,IF(F3="",(VLOOKUP(E3,Rates!A60:B61,2,FALSE))))

should do the trick...

3. Senior Member
Join Date
15th October 2003
Posts
188

## Re: Nest If And Vlookup Function

Hi

Change the formula to =IF(F3="YES",3.5,IF(F3="",(VLOOKUP(E3,Rates!A60:B61,2,FALSE))))

This should work.

Gizzmo

Excel Video Tutorials / Excel Dashboards Reports

4. I agreed to these rules
Join Date
27th April 2007
Posts
11

## Re: Nest If And Vlookup Function

Hi Dave

Thanks very much, that worked.

Tracy

Excel Video Tutorials / Excel Dashboards Reports

5. ## Re: Nest If And Vlookup Function

No worries - just realised that missed out a deafult (ie doesn;t met any of the other conditions) return value...

This would return a more meaningful value than FALSE
=IF(F3="YES",3.5,IF(F3="",( VLOOKUP(E3,Rates!A60:B61,2,FALSE)),"Not Matched"))

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•
porno