+ Reply to Thread

Results 1 to 16 of 16

subtract data using match and vlook

LinkBack
- LinkBack URL
- About LinkBacks
Thread Tools
- Show Printable Version
- Subscribe to this Thread…
Rate This Thread
- Current Rating
- ‎ Excellent
- ‎ Good
- ‎ Average
- ‎ Bad
- ‎ Terrible
Display
- Switch to Linear Mode
- Hybrid Mode
- Switch to Threaded Mode

Hybrid View

05-25-2017, 04:09 PM #1
Jonmo1

View Profile

View Forum Posts
Forum Guru

Join Date

03-08-2013

Location

Bryan, TX

MS-Off Ver

Excel 2010

Posts

9,763
Re: subtract data using match and vlook

Try this in D14 filled down to D15.

=VLOOKUP(B14,$A$2:$E$8,5,0)-C14
Register To Reply

+ Reply to Thread

« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

vlook or index match

By mma3824 in forum Excel General

Replies: 1
Last Post: 05-30-2014, 08:28 AM
Macro Help - Open Multiple Text Files one at a time, import data, use vlook tu match data

By hansonesh in forum Excel Programming / VBA / Macros

Replies: 0
Last Post: 08-09-2013, 05:54 PM
need to compare match the data of each column and then subtract it

By yageet in forum Excel Formulas & Functions

Replies: 2
Last Post: 06-11-2010, 01:31 PM
vlook up return more than one match

By dphair1979 in forum Excel Formulas & Functions

Replies: 23
Last Post: 08-28-2007, 10:46 AM
vlook/match/index

By nowfal in forum Excel General

Replies: 12
Last Post: 08-30-2005, 04:05 PM
Vlook up or index match

By jerry in forum Excel Formulas & Functions

Replies: 1
Last Post: 02-24-2005, 01:06 AM

Bookmarks

Bookmarks

Posting Permissions

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

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT -4. The time now is 06:29 AM.

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1