LinkBack URL
About LinkBacks
Hi,
I want a forumla that states IF cell F5 contains "paint" then return "@PAINT"
F5 may contain other values as well besides 'paint' so =if(f5="paint","@PAINT","") won't work.
Many thanks
Forumla help for SEARCH and IF
Hi,
I want a forumla that states IF cell F5 contains "paint" then return "@PAINT"
F5 may contain other values as well besides 'paint' so =if(f5="paint","@PAINT","") won't work.
Many thanks
Try:
Formula:
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Thank you
I have created the below:
Formula:Please Login or Register to view this content.
However the @SUBCON part isn't working when G64 contains "@JT", so long as G64 has no spaces (spaces " " substituted for "")
Any advice?
Last edited by SharpL; 10-10-2014 at 06:31 AM.
What are you trying to achieve with this part:
Formula:Please Login or Register to view this content.
Do you want to return "@SUBCON" if G67 contains "@JT" and F16 is a number? As that is how it is currently evaluating...
One sec, just noticed that. I'll ammend now.
Should be:
Formula:Please Login or Register to view this content.
But still doesn't work?
Last edited by SharpL; 10-10-2014 at 07:23 AM.
And still doesn't explain what you are trying to achieve....
Explain in simple terms which criteria you want to return "@SUBCON"
Apologises.
Forumla =
If F64 contains 'paint', return '@PAINT'
If F64 contains 'transport', return '@TRANSPORT'
If G64 contains '@JT', return '@SUBCON' - I need to remove spaces here via Substitute(G64," ","") to ensure '@JT' is captured, as this may return as any variation of "@ JT".
Then try:
Formula:Please Login or Register to view this content.
Perfect, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks