Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Need Help on combination of Vlookup


posted by pkpnair
Mon, Feb 10 2014

Downloads: 9
File size: 33.9kB
Views: 2,972
Need Help on combination of Vlookup

Hi,

 

I need a help. In the given attached file I need combination of Vlookup formula. I would like to check the condition at cell G4 and E7 matches with the data available in the sheet 2. Accrodingly the value at G7 should be changed. Hope anybody can help me.

 

Nair

Comments

pkpnair wrote re: Need Help on combination of Vlookup
on Tue, Feb 11 2014 1:33 AM
any body can help me ?
GenDemo wrote re: Need Help on combination of Vlookup
on Mon, Mar 10 2014 4:36 AM
hi pkpnair I looked at your file and I think you meant that H7 and not G7 should change. So I got a solution for you...I think it does what you want it to do. I just dont see if I can upload a file for you in return?
pkpnair wrote re: Need Help on combination of Vlookup
on Mon, Mar 10 2014 5:08 AM
pls upload the file
GenDemo wrote re: Need Help on combination of Vlookup
on Mon, Mar 10 2014 8:14 AM
Sorry, I am very new to the site. Where do I upload it? I dont see that I can reply with a file or anything...
GenDemo wrote re: Need Help on combination of Vlookup
on Wed, Mar 19 2014 8:41 AM
Please see : http://excelusergroup.org/media/p/11253.aspx
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.