If vlookup return blank means "paid", otherwise is "unpaid"

**Dewdrop** · 03-12-2019, 05:44 AM

Dear Experts,

Could you please help me on the formula for the vlookup to return either "paid" or "not paid".

Please see my table in the file attached.

Thank you very much.

Cheers
Dewdrop

**Special-K** · 03-12-2019, 05:47 AM

in F5
=IF(ISNA(VLOOKUP(E5,C$5:C$13,1,0)),"Paid","Not paid")
and copy down the column

**Dewdrop** · 03-12-2019, 05:51 AM

Dear Special-K,

Great, that's what i looking for.

Thank you.

If vlookup return blank means "paid", otherwise is "unpaid"

LinkBack

Thread Tools

Rate This Thread

Display

If vlookup return blank means "paid", otherwise is "unpaid"

Re: If vlookup return blank means "paid", otherwise is "unpaid"

Re: If vlookup return blank means "paid", otherwise is "unpaid"

Thread Information

Users Browsing this Thread

Similar Threads

Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas

[SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

[SOLVED] Invoice "Current" or "Overdue" (but need "Paid" option)

Excel 2007 : Match Values and Return "Present" "Absent" "Per Diem" or remain blank

if statement see "Male" or "Female" returning "Y" otherwise leave blank

=IF(D13="PAID","YES","NO") Can I change fonts colour

Bookmarks

Bookmarks

Posting Permissions