I have tried the following IF statement
=IF('Unassigned Players'!E4:E18="Colin",'Unassigned Players'!C4:C18,"")
but that just returns the #VALUE! error.
For information "Colin" exists in 'Unassigned Players'!E7 and I would like to copy the cell from C7
Perhaps
=IF(countif('Unassigned Players'!E4:E18,"Colin"),"Colin","")
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.
Thanks for your quick reply Fotis1991. However this is not quite what I need.
The first bit works ie
=IF(countif('Unassigned Players'!E4:E18,"Colin") and finds the entry for Colin at E7. However it then populates the cell with Colin but I want the cell populated with whatever is in column C on the same row as where it has found Colin. Hope that makes sense?
Do you mean?
=INDEX('Unassigned Players'!C4:C18,MATCH("COLIN",'Unassigned Players'!E4:E18,0))
Brilliant - that has done the trick. Exactly what I needed - thanks ever so much for your help.
......................
Sorry Fotis1991 - one issue - if Colin doesn't exist (which it might not) in Column E then the cell is populated with #N\A - is it possible that if Colin is not in column E the cell can be left blank?
=iferror(INDEX('Unassigned Players'!C4:C18,MATCH("COLIN",'Unassigned Players'!E4:E18,0)),"")
Brilliant once again Fotis1991 - thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks