Hey, can someone take a look at F8 and G8 on the attached workbook and let me know why index/match doesn't differentiate between "," and "?" ?
It's returning the same answer for both.
Thanks!
Last edited by mewingkitty; 03-15-2010 at 03:09 AM.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
Hi kitty,
the ? is a wildcard character that can be used with Match. If you want to find an actual question mark, you'll have to precede it with a tilde ~ as in
=IFERROR(IF(ISBLANK(G$7),"",INDEX(Sheet1!$F$1:$F$15,MATCH("~"&Sheet2!G$7,Sheet1!$E$1:$E$26,0))),"*")
So in row 8, starting in column F, you can use
=IFERROR(IF(ISBLANK(F$7),"",INDEX(Sheet1!$F$1:$F$15,MATCH("~"&Sheet2!F$7,Sheet1!$E$1:$E$26,0))),"*")
and copy across
hth
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
Sweet,
Marked the thread as solved... What's the basis behind that syntax? I can't picture how that's being interpreted by Excel...
mew?
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
see here: http://office.microsoft.com/en-us/ex...091681033.aspx
enjoy!
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking the
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks