LinkBack URL
About LinkBacks
hopefully someone can help me,
attached is an example of what i need help with. my knowledge of excel just scrapes the beginnings of vlookup!
example3.xls
all i need is to show all of the names from sheet 2 on sheet 1.
thanks in advance,
Declan
hopefully someone can help me,
attached is an example of what i need help with. my knowledge of excel just scrapes the beginnings of vlookup!
example3.xls
all i need is to show all of the names from sheet 2 on sheet 1.
thanks in advance,
Declan
Last edited by Declan.Ryan; 11-13-2012 at 07:38 AM.
In J2 and copy down and across.
=INDEX(Sheet2!B$2:B$6,MATCH(Sheet1!$C2,Sheet2!$A$2:$A$6,0))
EDIT: And if you don't want to see zeroes..
=IF(INDEX(Sheet2!B$2:B$6,MATCH(Sheet1!$C2,Sheet2!$A$2:$A$6,0))=0,"",(INDEX(Sheet2!B$2:B$6,MATCH(Sheet1!$C2,Sheet2!$A$2:$A$6,0))))
Last edited by Fotis1991; 11-13-2012 at 07:19 AM. Reason: Edit
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
do you mean like this?
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Absolutely spot on both of you, thank you so much for your help.
You are welcome Declan, from both of us!
Thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks