Look up across several columns (same row), and return value in another cell

Hi

I am trying to look up values in say 5 columns of each row, if the values are the same in each column, return that value to another cell.
If the values are not the same, return a special character like "*"

Example:
1.Look up a name in Sheet1, A2, in Sheet2 cells A2,B2,C2,D2,E2
2. If the values in A2,B2,C2...are the same, return that value to Sheet 1, cell B2
3. If the vlaues are different, return "*" in Sheet 1 B2

Basically, I'm looking up names in Sheet1, and looking for the point values in Sheet2, so that if they are all the same, I'll have that number returned to Sheet1 or a "*" to denote that the points are not the same.

Thank you for any help on this.

Dan

you could probably build something around a countif(), but hard to say without seeing a sample workbook

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

In your example, in H3 copied down

=IFERROR(IF(COUNTIF(INDEX(Participation!$C$5:$K$11,MATCH(D3,Participation!$A$5:$A$11,0),),VLOOKUP(D3,Participation!$A$5:$C$11,3,FALSE))=9, VLOOKUP(D3, Participation!$A$5:$C$11,3,FALSE),"*"),"")
Does that work for you?

Thanks Danny and VKS.
VKS, don't worry about it, I still learn new ways to use Excel here all the time.

Hello Dannypak,
Check the attached file, you may like it.
It has one additional column at the end(In participation sheet).
This takes care of the missing values of column D(Region sheet) in participation sheet also.