If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 news | | 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? | | |
Thread Tools | |
Display Modes | |
|
|