Computer Tech, Gaming & Electronics THIS SPACE OPEN FOR ADVERTISEMENT. YOU SHOULD BE ADVERTISING HERE!
Silicon Valley.
Tips & tricks, tech support, home theatre, online gaming, reviews, latest news... |
 | 
10-20-2017, 07:58 AM
|
#1 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
Failed 1,234 Times in 307 Posts
| Any Excel gurus can help me
Basically what I'm trying to do is on the first spreadsheet I need a "Yes" in the column under Eligible for Superstar. There is a bunch of names that I need to cross reference with the second spreadsheet. So if the names are on the second spreadsheet, then yes for Superstar, if no, then no..
Is this possible? It's on the same workbook  
Thanks
| 
|  | |
10-20-2017, 08:11 AM
|
#2 | | not the mod you're looking for
Join Date: Sep 2009
Posts: 3,744
Thanked 1,537 Times in 556 Posts
Failed 83 Times in 32 Posts
|
So what you want is if the second sheet matches the names in the first sheet, insert the text, "yes" for superstar?
| |
| | |
10-20-2017, 08:15 AM
|
#3 | | OMGWTFBBQ is a common word I say everyday
Join Date: Apr 2006 Location: Tres Ciudades
Posts: 5,407
Thanked 3,680 Times in 1,522 Posts
Failed 150 Times in 53 Posts
| https://www.mrexcel.com/forum/excel-...no-values.html
or hlookup if the values you're cross referencing are in a row
__________________
"There's a lot of dead people who had the right of way."
"Never argue with stupid people, they will drag you down to their level and beat you with experience."
"I have a lot of beliefs, and I live by none of them. They're just my beliefs, they make me feel good about who I am. But if they get in the way of a thing I want, like I wanna jack off or something, I just do that." | |
| | |
10-20-2017, 08:44 AM
|
#4 | | not the mod you're looking for
Join Date: Sep 2009
Posts: 3,744
Thanked 1,537 Times in 556 Posts
Failed 83 Times in 32 Posts
| Quote:
Originally Posted by 6o4__boi  | That link is your answer!
From the screencap you gave us, it would look like this:
=IF(ISNUMBER(MATCH(Cell number,Range you want to cross reference,0)),"Yes","No")
Plug this into your "eligible superstar" cells and it will return the values.
Last edited by FN-2199; 10-20-2017 at 10:54 AM.
| |
| | |
10-20-2017, 09:37 AM
|
#5 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
Failed 1,234 Times in 307 Posts
|
I tried it using values on the same spreadsheet but got an error  | |
| | |
10-20-2017, 10:52 AM
|
#6 | | not the mod you're looking for
Join Date: Sep 2009
Posts: 3,744
Thanked 1,537 Times in 556 Posts
Failed 83 Times in 32 Posts
| Quote:
Originally Posted by FerrariEnzo I tried it using values on the same spreadsheet but got an error | Sorry, remove the quotations from the first part formula but leave quotations for "yes" and "no". add a $ in front of the letter ($A3) to lock in the column, then drag the formatting down your superstar list
| |
| | |
10-20-2017, 11:15 AM
|
#7 | | I answer every Emotion with an emoticon
Join Date: Feb 2005 Location: somewhere
Posts: 7,906
Thanked 2,485 Times in 1,007 Posts
Failed 1,234 Times in 307 Posts
|
It's all good... I got help from mrexcel forum using macro...
Thanks
| |
| | |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is Off
| | |
All times are GMT -8. The time now is 06:12 PM.
|
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
The banners on the left side and below do not show for registered users!
