ok, so i can NOT figure this out at all. I have a vlookup in cell C3 that returns the value "BLUE" based off of the value of cell A3. in D3, i have the formula: =IF(C3="BLUE","MARY","") but i am getting a blank cell...excel is not seeing the value MARY in the cell i think. is there another way to get this value? what am i doing wrong?
are you saying c3 has BLUE in it and this formula returns blank?
=IF(C3="BLUE","MARY","") if so c3 doesn't contain just "BLUE" it may have spaces before or after it or other invisible non printing characters
what does =len(c3) return if it is not 4 then there is something else in the cell
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Suggest you post a sample workbook. Doesn't look anything wrong with the formula.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
C3 has the vlookup formula in it. there is a large table it grabs data from...so the cell C3 actually has this in it: =vlookup(A2,mainrng,3,false) in this case, it returns BLUE... my problem is in D3. i'm trying to use the formula: =IF(C3="BLUE","MARY","") . the formula SHOULD return "MARY" since the cell C3 says blue, based off the vlookup. however it returns a blank. i think excel is looking at the value of C3 as the vlookup formula and not the result of the vlookup. i can not figure out how to base the if statement off of the vlookup formula result.
read post #2
No, the formula in D3 looks at the result of the vlookup formula in C3.Originally Posted by fredderf81
What Martin is trying to say is that the Vlookup formula is not returning EXACTLY "BLUE".
It may be returning " BLUE" or "BLUE "
With an extra space or somethign.
What does =LEN(C3) return?
Posting a sample book would be most helpful.
Jonmo1:I said thatPosting a sample book would be most helpful.
Good job
i think it's time to post a workbook
AHH, it just took me reading the post over again =) .... as a bad habit, i had in the formula "*BLUE*" which did not return what i wanted. .... removed the 2 * and it works .
thanks for setting me straight!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks