Match and index

Closed

Angel-Face - Nov 21, 2009 at 03:21 AM
Blocked Profile - Nov 22, 2009 at 12:48 AM

Hello,

Hello,

ive been struggling the entire morning to figure out a formula.

i have two sheets, i want to match columnD on sheet2 to columnA in sheet1 but at the same time i need columnBs data in sheet1 to be dropped in the formula column in sheet2..

=INDEX(Sheet1!A:A,(MATCH(D3,Sheet2!D:D,0)))

this is the formula i came two but its not giving me what i want :(

pleeeeeeeeeeeze take me out of my misary

thanks

Match and index
Music match jukebox - Download - Audio playback
Position of mouse pointer does not match screen coordinates clicked - Guide
Royal match pc - Download - Puzzle
Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
Facebook says my email does not match an account - Facebook Forum

1 response

Answer 1 / 1

Blocked Profile
Nov 22, 2009 at 12:48 AM

Dear Angel Face,

Please consider checking the solution to your problem in the below

similar post that has already been answered:

https://ccm.net/faq/4938-how-to-compare-two-excel-sheets-and-combine-unique-data

Thanks in advance.

Similar discussions

Facebook says that my email doesn't match my facebook email

Compare values in two columns and return the value from third

Modern Warfare 2 online cant find matchs why

Facebook is not allowing me to enter my account

Facebook account not match

Similar discussions

Subscribe To Our Newsletter!