LinkBack URL
About LinkBacks
I have attached a spreadsheet with the issue that i am having. Its probably quite a simple solution but im having a few issues with it.
Any help is appreciatedExcel help - June 13.xls
I have attached a spreadsheet with the issue that i am having. Its probably quite a simple solution but im having a few issues with it.
Any help is appreciatedExcel help - June 13.xls
Try in B2 and copy down.
=IF(ISERROR(IF(COUNTIF($E$2:$E$6,A2),"",INDEX($J$2:$J$5,MATCH(A2,$I$2:$I$5,0)))),"",IF(COUNTIF($E$2:$E$6,A2),"",INDEX($J$2:$J$5,MATCH(A2,$I$2:$I$5,0))))
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.
Hi Fotis,
No luck, the MATCH(A2,$I$2:$I$5;0)))) did not work,
Thanks
I just didn't replaced the semi colon(as we use in Greece) with comma. Pls do it and formula will work.Originally Posted by ryanch69
Apologies, this still does not seem to work when changing one or both
....................................
Thanks Fotis, this is now working,
Thankyou
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks