Hello,
I want to compare two columns of data, and where ever there is a match, to subtract.
So in attached spreadsheet, I want to compare column A with column F, and if there is an exact match, then display the difference of coulmn i and d, all else leave blank.
See desired result in column K
How can I do this via sumproduct or vlookup, or any other method?
Thanks
Last edited by VegasL; 11-18-2010 at 11:45 PM.
Hi,
In K3 and copied down
HTH
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
VegasL,
Detach/open workbook VegasL - EF752642 - SDG10.xls and see the VLOOKUP formulae beginning in cell K3.
Have a great day,
Stan
Windows 10, Excel 2007, on a PC.
If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
Thanks guys for both helping and sorry for the late reply.
@richard - formula worked perfectly, but a bit complex for me. I'll have to study index/match a bit more to grasp it totally
@stan - formula also worked perfectly, very interesting use of vlookup, very simple - i didnt realize you could subtract via vlookup like that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks