₦airaland Forum

nefertitiram:
Mini me was born at 1pm US time yesterday, weighing 4.3kg . Birth story when I settle down

tyconcepts:
I can't wait to drop my LO coz at 35wks+ am already tired and eager. FTM tho'

Had an experience on Saturday, no appetite for anything in the house, mama put's food was the only thing I crave...DH took me to one in town and mehnnn I enjoyed the food (Vegetable soup & Eba) but like 10minutes later, I couldn't explain my restlessness, told DH I feel like vomiting which was unusual coz I never experienced MS throughout. I vomited all I ate including my drugs, yet the restlessness didn't end...Vomited like twice again and DH was fidgeting for us to go to the hospital but I stubbornly refused....Later felt good after drinking hot pepper soup but I still wonder what could have caused the whole vomiting saga. Anyone who can explain please??



#TeamSeptemberForSwiftDelivery

cc my lovely teammates : helovesme, jennifer89, abiagirl777, doubledouble, deezou, cutiereborn, dunasy, niyyah, gocare and a lots of others

Jennifer89:
awww congratulations!!!! team September mummies are strong and vibrant. i am the official class captain (5 star general) and was decorated today. these are the names of some sept mothers Cutierborn, Deezou, dunasy,
helovesme, niyyah, olalaayo1710, gocare and doubledouble.

ozycy:
Lol, let me sharply cancel your name from our list . In your mind now, you don overtake us naaaa

Niyyah:
Welcum sis,c our class captain for registrationn.. May we all deliver wit ease In Shaa Allah#teamseptember#

cammyjr:
Yes the deadline is 16th. It's safe to take it before then. All the best

ozycy:
Ahhh Stadora, u bin talk say u be teamoctober and even took 3rd position. How come you don change mouth enter team September now now? explain yaself

Beryl15:
Come and join me sing hallelujah o!
My princess is here. she arrived at 3:07pm and weighed 6lbs 14oz.
BS later, lemme rest.

beegail1:
I hail all d mamas in d house. FTM n silent reader n follower of this wonderful thread.
33weeks gone #teamseptemberrocks.

zaidasqueen:
who is applying for the chevening scholarship? I am interested so that we can work together

Tallgirlslim:
My wonderful Nairaland land friends who saw me through a 9 month journey of life, I have come to announce that my beautiful little princess was born yesterday at 4.08kg.

Mother n treasure are doing great...

yearegods:
Okay then, since you're interested, I'll just tell you this: drop your mobile number here when you respond, or send your number to any of my mobile numbers. You can get my numbers on this post where I briefly describe SHOOLFORCE: https://www.nairaland.com/2408426/schoolforcetm-powerful-school-management-software, here on nairaland. When you do, I'll call you up so we can have a chat. You'll also be added to my list, so you can attend the training where I formally introduce and demonstrate my software, as well as discuss with the other guys who have also indicated interest in the system. From there, you can meet me in person, so we can determine how you can fit into the entire process.

God bless...

gocare:
Why you dey fear 2nd space stadora?

ozycy:
noted

ozycy:
If team July no wan do roll call, make team August take over . Team October, who be our class captain? My name should be number one in the list, I ve booked space, no chancing please ooo

onyeakwanga:
HAPPY NEW MONTH TO ALL

corrall:
Hello my dearest mothers, join me in thanking God, my little angel arrived at 8.30am on Saturday, 27th June, it awash not easy, but it was worth it. Not to worry, d just de come, I never really don sleep.

Funjosh:
Buy a laptop, a moderm, a generator and a printer. Start online registration biz then later you can include phone accessory to it.

stadora:
Congratulations ahnie n safe delivery to al pushin mamas.
pls 2 experienced mamas in d house, I want to no if soya beans milk, both d liquid and d powdered one is good 4 pregnant women n d LO, as am thinkin of startin d business of producin d soya milk n be selling.
I learnt from ds thread dat Zobo drink is not good 4 preg women, so wanna confirm 4 dat of soya milk b4 I go in2 it. thanks

Bennyzino:
Sent to over 15 contacts.. It's the best dragnet questions I have seen..

HARMYMY:
Alemo50 pls help me out

manny4life:
Finally


What is VLOOKUP?

V + LOOK+ UP = VLOOKUP

V = Vertical

LOOKUP = Search

VLOOKUP is a function, a predefined formula used to search for information across columns in a table. This function serves a very important purpose, when you have a large data set and you're trying to locate an a text field, number of any sort of string, rather than scrolling several thousands of rows below, this function comes handy.

[img]http://1.bp..com/-gfbhnR028Vk/Usx1iiLClUI/AAAAAAAAAes/YEOqK5BVREE/s1600/Image+1-a.jpg[/img]

For the purpose of this illustration, above is a sample table file with basic information.

The table above is an inventory manifest list, there are several "rows" of data with usable information in each column. Assuming that I had 1,000 rows of data and I wanted to search for a "Part #", I will use VLOOKUP feature to automate my search and avoid repetition.

On this table, I will use the part # to lookup the price, therefore, the Part # is our lookup field.

A good example of where VLOOKUP application is utilized is using this function to fill out "INVOICE INFORMATION. I will explain more in details.


The table has SEVEN columns of data

Column a: Part numbers (#)
Column b: Fulfillment Center
Column c: Product group
Column d: Item name (description)
Column e: Qty
Column f: Price
Column g: Extended cost ( # of qty x price per piece)



Now the next portion is using VLOOKUP to search for information.

NOTE: The Lookup Data MUST always be the first left column, this makes the argument easier. In the table, when I enter the function argument, the part number will be our lookup data.

Next, below is a table showing the function

[img]http://1.bp..com/-5Xn6RfeS3e0/Usx1kU-TQPI/AAAAAAAAAe0/o92BauCI0no/s1600/Image+1-b.jpg[/img]

This is the function argument for VLOOKUP

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])


a. lookup_value: This is the value used as a search reference. In the table above, this would be the "part #" = "C6"

b. table_array: This is search reference table. In this case, I will reference the previous tab "Master file", and select B5:H27

c. column_index_num: This is the column referenced to get the resultant information from. In this case, the pricing is what I want. NOTE, it's asking for the "num" meaning number, therefore, I have to count from the left of the "table_array", which is number SIX (6)
d. [range_lookup]: This is explanatory, unless you're seeking an for rounded results, USE the "FALSE" option... False ALWAYS returns an exact match. In this case, I am looking for an exact price for the unique part number.


Combining the information will give us this function argument.

=VLOOKUP(C6, Master File '!B5:H27,6,FALSE)

[img]http://3.bp..com/-fqIj1Mie5wA/Usx1lzhLC_I/AAAAAAAAAe8/-tXGzu65oBc/s1600/Image+1-c.jpg[/img]

Having entered this function argument in C7= pricing, because the precedent cell is "null" value, it will return a "#N/A" result. However, the moment I entered a part #, it populates the pricing for that item. This is how VLOOKUPis used. Furthermore, I applied the same rule to the last two and the right should be used for activity exercise.

NOTE: The VLOOKUP function table is different from the previous table, this is because the previous table does not have $$$ signs. Absolute and Relative reference are very important because when a cell is moved, if you want to maintain the cell integrity, it is imperative to make it "ABSOLUTE". To do this, you have to change the reference from "Relative" to "Absolute", by highlight the cell information such as "B5" and press F4. This toggles between both references. I used absolute reference because I wanted to keep the absolute range of B5:H27.

iamboss:
The assessment will be shl comprising of verbal.... passages with questions... yes, no, cannot say answers...... quantitative reasoning.... tables and Graphs. Speed and accuracy is essential. If u can get 2008 to 2009 gmat and practice shl questions online it will help.

durandal:
Urgent employment for Literates

I strictly asked for literates because they’ve got the ability to read and write i.e. read instructions and write as instructed. So if you don’t fall in this category, don’t even bother to read further because this is not meant for you.

Now over to you (great people) I have personally come on to this platform to source for great minds that I can work with. To begin with, my name is Obed Uche and I am a content manager. I currently run small content outsourcing company with quite a number of dexterous brains. But of late, we could no longer meet up with clients’ demand because it really has gone on the increase. That’s why I’m hiring today.

If you think you’ve got the stuff to make a great write-up, do not hesitate to contact me. I don’t have time to read trash, so keep your prestigious resume or CV to yourself. Just send a mail to obeduche@gmail.com with “Hire me” as the subject and I will take it from there.

As soon as I receive your application, I will send you a simple writing assignment which will be used to evaluate your efficiency. Upon selection, you will be invited to work with us on our web office where constant work will be assigned to you. For beginners I pay N1 per word, so if you are assigned with a 500words assignment you will receive N500. This is a fair payment and you are sure to rise if you are consistent.

I pay every first Fridays of every month. So why the wait, act now! Time is not on our side.