Using If and Vlookup [Properly Terminating Function Q]

[iDontDoNormal]

Hello there guys!

Can anyone please help me with this one? Here is a sample spreadsheet that I am working on.

I don't know why. But, seems like I am missing something here.

The Q's_Database is a collection of all the Q's (Q1, Q2, Q3, Q4)

I just need to check if the Campaigns that are in the "checker" are or is existing in the DB or not.

So, I used Vlookup. Is there any other way where I can use a formula and as to where it is more effective for this task.

I might've been using the wrong function or maybe it's just how I used / combined / terminate the function or just how I use " ) ".

QUEUE CHECK [ OPTION 1 ]

=IF(D2="harvesting","Harvesting",IF(D2="sent","Sent",IF(D2="ready to be sent","Send Me",IF(D2="harvesting complete","Harvesting Complete",IF(D2="Complete","Complete",IF(D2="building list","not ready",IF(D2="ready",VLOOKUP(C2,'Q''s_Database'!B:B,1,0))))))))

Queue Check 2 [OPTION2]

=IF(D2="harvesting","Harvesting",IF(D2="sent","Sent",IF(D2="ready to be sent","Send Me",IF(D2="harvesting complete","Harvesting Complete",IF(D2="Complete","Complete",IF(D2="building list","not ready",IF(ISNA(VLOOKUP(C2,'Q''s_Database'!B:B,1,0)),"Queue Me","Set Me Up")))))))

If D2 = ready; vlook it in Q's DB and tell me if campaign exists,

IF yes, "Set Me Up"
If not, "Queue Me"

------------
Please ask away for any questions.

Thanks!

[skywriter]

Upload your file to here.

ViewPic

[iDontDoNormal]

Thank you for the reply Sir!

I just downloaded the attached file from here. https://docs.google.com/spreadsheets...gid=2131547942

I am not pretty sure if the formula's would worked as they may from Google Spreadsheet > Excel.

[HangMan]

Would this give you what you need...

Please Login or Register  to view this content.

[iDontDoNormal]

Pelase take a look at this Sir HangMan.

https://docs.google.com/spreadsheets...gid=2131547942

Column C has your formula.

C13 - C15 is already in the Q's Database. It should display as "Set Me Up".

** To the Mods; I do hope this doesn't spoil the forum since I keep on referring the members to the Google Spreadsheet instead of a Excel Workbook.

Please inform me if I am sort of not following any of the rules.

Thank you!

[HangMan]

Hi Jay,

That's because on your actual worksheet you said "Queued" rather than 'Set Me Up'

These Campaigns needs to be checked if they already exist on the Q's Database. If Campaigns that are set as "ready" in this tab are existing in either Q's, it should give me a message like "Queued"; else, "Queue Me"

so all you need to do, in Excel at least is change the formula to:

Please Login or Register  to view this content.

It is working in Excel (see attached), but seems perhaps not in Google Docs? I'm not familiar with Google Docs, as in I don't use it, so unsure of the differences between the two.

[iDontDoNormal]

Yes Sir! That's one,

The thing is, in your supplied formula, it indicated IF(MATCH(C2,'Q''s_Database'!$B$2:$B$64,0)

which should be IF(MATCH(C2,'Q''s_Database'!$B$2:$B$68,0)

Match.. This would be the first time that I would be using this function. hahaha! uhm.. I don't fully get as to why use match.. how it is used in this scenario.. does it mean that it would look for the precise match? and that vlookup is not that accurate in pinpointing values?

---

Thanks Sir!

A + for you !

[HangMan]

Sorry, that's because I removed the blank rows in your sheet when I was testing, just change to $B$68...

I tested it in Google Docs and all seems to work...

MATCH simply checks to see whether or not a value is in a range, using '0' at the end will test for an exact match...

Hope that helps...

[iDontDoNormal]

No need to apologize Sir! Relax! ^^

All is well.. Thank you again for helping a newbie like me.. and till next time!

Paalam!