Hello. I am facing a problem using Hlookup function. I am using Hlookup to do a control check of consolidation i am doing here, however it only returns the first found value instead of all correct values (or range).
I am attaching a file with an example. In the file formula is used in Supply(S) sheet on row 73.
Last edited by Strazdas; 12-27-2013 at 02:11 PM.
Thats what vlookup/hlookup does - it returns the very 1st match it finds...and then stops searching.
Try this instead...
=IF(M72=SUMIF('Supply(R)'!$C$2:$CL$2,'Supply(S)'!M$2,'Supply(R)'!$C$94:$CL$94),TRUE,M72-SUMIF('Supply(R)'!$C$2:$CL$2,'Supply(S)'!M$2,'Supply(R)'!$C$94:$CL$94))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This has worked. Thank you. I am marking this as solved
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks