We help IT Professionals succeed at work.

Looking to locate and input a value in Excel based on three criteria

168 Views
Last Modified: 2018-02-15
Hi,

I'm basically looking to fill column 'D' in the first sheet (Data) based on the Rates sheet (second tab). If the the first three columns match in both cases then I would like to have the rate inputted.

Please let me know if you have any suggestions :)
Excel-Lookup-Value.xlsx
Comment
Watch Question

Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks Subodh! Works Great!

Author

Commented:
Swift and great reply from Subodh
Subodh Tiwari (Neeraj)Excel & VBA Expert
CERTIFIED EXPERT
Most Valuable Expert 2018
Awarded 2015

Commented:
You're welcome Kareem!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.