LinkBack URL
About LinkBacks
New example: in columns G AND H, I HAVE A FORMULA. I would like it to return
w in g, and a L in h. Meaning if the results is win, then a w would go in g. And if a loss, a L would go in H. is this possible to do?
Thanks
BKG
New example: in columns G AND H, I HAVE A FORMULA. I would like it to return
w in g, and a L in h. Meaning if the results is win, then a w would go in g. And if a loss, a L would go in H. is this possible to do?
Thanks
BKG
Last edited by Fotis1991; 09-25-2013 at 01:11 PM.
Dear BKG Sports, i think your work book has links from other work book
copy this formula in G3 =IF(VLOOKUP(A1,"select your reference here",7,FALSE)="W",VLOOKUP(A1,"select your reference here",7,FALSE),"")
copy this formula in H3 =IF(VLOOKUP(A1,"select your reference here",7,FALSE)="W",VLOOKUP(A1,"select your reference here",7,FALSE),"")
yes thats the wrong example, sorry about that
What do you mean by reference?
Hi moderator, I'm not sure what you want me to say on the Title?
I changed your title according forum rules. Pls be sure that you'll follow these rules next time!
Good luck with your thread!
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.
In G3
=IF(VLOOKUP(A1,'C:\Users\joverack\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\9VRF8OG9\[NBA EXP.xlsx]GAMES'!$A$7:$T$12,7,FALSE)="W","W","")
In H3
=IF(G3="W","","L")
Thanks Moderator for doing that, very much appreciated!
I(we=the moderators) don't want to kick off no one at all! We are here to try to apply the rules of this forum.
We may be worrying more than you when you are forcing us to become hard!
Hey Jonmo1, that didn't work.
I was going to attach another sheet and put it in sheet2, but it won't let me do that.
Let's say in sheet 2, in the range of a3:h8, and in g5 there is an L in that cell. On sheet1 I want it to return that L in h3 in sheet 1. If it was a W i would want it to return in g3.
Hope this helps
Thanks
BKG
Maybe..?
In H3
=IF(Sheet2!G5="L","L","")
In G3
=IF(Sheet2!G5="W","W","")
Life's a spreadsheet, Excel!
Say thanks, Click *
Hey Ace_xl, that worked, but I would have to log in each row individually. It would be alot faster in the whole range.
I've tried a few different ways, but doesn't seem to work.
Can someone figure this out!
Thanks
BKG
Is there anyone who can help me on this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks