help with VLookup

Computing.Net > Forums > Office Software > help with VLookup

Original Message

Name: HB Hays
Date: January 6, 2005 at 09:46:26 Pacific
Subject: help with VLookup
OS: xp
CPU/Ram: cpu 2.93 mhz/ram 1024

Comment:

Here's my existing formula (Thanks to all of your help) =VLOOKUP(A1,'Zone 1'!$C$4:$D$1288,2,FALSE)
If it looks up A1 and doesn't find it on the 'zone 1' sheet, can I have it:
a. return a zero?
b. return a word that will allow me to sum the column and the word won't screw up the formula?
If so, what would the formulas look like?

Report Offensive Message For Removal

Response Number 1

Name: Grok Lobster
Date: January 6, 2005 at 10:13:40 Pacific
Subject: help with VLookup

Reply: (edit)

=IF(ISERROR(VLOOKUP(A1,F7:F12,1,FALSE)),"not found","found")
Change the references as needed

Report Offensive Follow Up For Removal

Response Number 2

Name: HB Hays
Date: January 6, 2005 at 11:07:55 Pacific
Subject: help with VLookup

Reply: (edit)

Grok,
I can't thank you enough. It works perfectly! Thanks again.

Report Offensive Follow Up For Removal

Response Number 3

Name: HB Hays
Date: January 6, 2005 at 11:24:36 Pacific
Subject: help with VLookup

Reply: (edit)

Grok,
It worked fine on ones that had an error, but now the lookups that should return a value, say "false" ????
I'm using:
=IF(ISERROR(VLOOKUP(A1,'Zone 1'!$C$4:$D$1288,2,FALSE)),"EMPTY")

Report Offensive Follow Up For Removal

Response Number 4

Name: ps-acc-320
Date: January 6, 2005 at 12:32:25 Pacific
Subject: help with VLookup

Reply: (edit)

=IF(ISERROR(VLOOKUP(A1,'Zone 1'!$C$4:$D$1288,2,FALSE)),"EMPTY",VLOOKUP(A1,'Zone 1'!$C$4:$D$1288,2,FALSE))

Report Offensive Follow Up For Removal

Response Number 5

Name: Bryco
Date: January 6, 2005 at 12:40:47 Pacific
Subject: help with VLookup

Reply: (edit)

Or
=IF(ISERROR(VLOOKUP(A1,'Zone 1'!$C$4:$D$1288,2,FALSE)),0,VLOOKUP(A1,'Zone 1'!$C$4:$D$1288,2,FALSE))
Meaning if error is found then zero else vlookup.
so you can have a workable value.
Bryan

Report Offensive Follow Up For Removal


Need help with IF statement in Exce Help with excel if statements Help with excel formula Excel Formula, need help! Excel Function (Vlookup)	Help With Excel Please. Help with strange Excel Formula Help with microsoft office 2003 tem Help me with word! I need a help with word

Response Number 6

Name: Grok Lobster
Date: January 6, 2005 at 13:38:11 Pacific
Subject: help with VLookup

Reply: (edit)

The gist of it is that you need another response in your formula after "empty" for the condition where it is not empty. You can enter the vlookup formula as ps-acc and Bryan did or you can enter text or the result of another formula.
=IF(ISERROR(VLOOKUP(A1,'Zone 1'!$C$4:$D$1288,2,FALSE)),"EMPTY","NOT EMPTY")

Report Offensive Follow Up For Removal

Outlook 2000 will not shu...

Word Tables

Use following form to reply to current message:

Name: From My Computing.Net Settings E-Mail: From My Computing.Net Settings Subject: help with VLookup

Comments:

  Homepage URL (*): 
Homepage Title (*): 
         Image URL:

How do you add voice to a microsoft

IBM Thinkpad R40 - Operating System

Possibly a New Video Card?

Virus alert!

Bios trouble

All Posts Awaiting Replies