hi
I have two data to be compared, The first data on sheet 1 ( data 1) and another in the sheet 2 ( data 2). I try to use index and match function but the result is the wrong data.
Thanks in advance for any help.
herukuncahyono
hi
I have two data to be compared, The first data on sheet 1 ( data 1) and another in the sheet 2 ( data 2). I try to use index and match function but the result is the wrong data.
Thanks in advance for any help.
herukuncahyono
Last edited by herukuncahyono; 05-27-2010 at 02:17 AM.
herukuncahyono,
Check out the attachment for a possible solution. You were on the right track.
Side Note: you had the named range fruits referring to the wrong list of fruit for that INDEX MATCH formula to have been effective. Here is a link that explains the INDEX MATCH combo: http://www.contextures.com/xlfunctions03.html
Thanks,
Ryan
A word to the wise is infuriating. - Hunter S Thompson
hi Ryan Murtagh
useful solution, thanks for sharing your knowledge.
thanks for explain my question with a web link,
regards
herukuncahyono
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks