Help with VLOOKUP

[EQUILIBRIUM89]

Hi everyone,

I am new to Vlookup and am comparing two columns in one spreadsheet tab to multiple columns of data in another tab. If the data is found in the second tab, then return the 6th column in the second tab.

For instance,
The first tab, cell C2 contains transactions, cell E2 contains the corresponding accounting module.

Second sheet contains several columns one with the accounting module and another with the transactions.

If the transactions in the first page are found in the second spreadsheet then return a value found in 2nd spreadsheet.

 

[pdevito3]

Here is the first link I found on vlookup. I prefer index match. How to Use INDEX MATCH

=INDEX('Sheet Name'!FullRange,MATCH('Sheet Name'!LookupValueCell,'Sheet Name'!LookupValueSingleColumnRange,0),Column # in Full Range to return)

Example, Looks at data in A2:C10 of the "First Sheet" Sheet and looks through C2:C10 for the value in A2 on second sheet. It will return the value in the row that matches in column 2.

=INDEX('First Sheet'!A2:C10,MATCH(SecondSheet!A2,'First Sheet'!C2:C10,0),2)

 

[EQUILIBRIUM89]

Thank you, can I PM you for help on this?

 

[pdevito3]

Better to post your questions here so other can benefit as well