Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default What formulas to use for logic in excel


I have two excel files.
One file has vendor number and vendor name.
The second file has vendor number and payment information based on vendor
number.
I want to use the two files to say if vendor number on my paid filr (second)
is showing up then match it to the vendor number on my (first) file and
popuate the name of the company for me on my (second) file.

This will allow me to see what companies have paid.

I am wondering what is the best formula for this logic?


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,440
Default What formulas to use for logic in excel

Use the VLOOKUP() function

Look here for a tutorial:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Kimber" wrote in message ...
|
| I have two excel files.
| One file has vendor number and vendor name.
| The second file has vendor number and payment information based on vendor
| number.
| I want to use the two files to say if vendor number on my paid filr (second)
| is showing up then match it to the vendor number on my (first) file and
| popuate the name of the company for me on my (second) file.
|
| This will allow me to see what companies have paid.
|
| I am wondering what is the best formula for this logic?
|
|


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Understanding the logic and criteria of Array formulas Starguy Excel Worksheet Functions 2 April 29th 07 02:34 AM
Logic Formulas BWatson10 Excel Worksheet Functions 3 January 4th 07 03:51 PM
Need help w/ logic statement in excel bettinab Excel Worksheet Functions 2 August 26th 06 02:00 AM
Excel Logic Statements Leach Excel Discussion (Misc queries) 2 April 26th 06 02:07 AM
Excel logic fujimi-cho Excel Discussion (Misc queries) 3 October 5th 05 11:26 AM


All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"