Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
help with VLookup
Name: HB Hays Date: January 6, 2005 at 09:46:26 Pacific 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?
Name: Bryco Date: January 6, 2005 at 12:40:47 Pacific
Reply:
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
0
Response Number 6
Name: Grok Lobster Date: January 6, 2005 at 13:38:11 Pacific
Reply:
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.
Summary: I have a worksheet with a summary page and a detail page. The IF statement is in one cell on the Summary page =IF(Detail!H6="Voided",-Detail!D6,0)and references the detail page. Of course this only wo...
Summary: I'm trying to figure out the formula for an average of some numbers without the low and high numbers to be factored in the average. ie. I have 7 numbers. I want the high and low taken out, and hav...
Summary: You guys are awesome. I just registered at computing.net and saw one of your responses to someone who has somewhat of a similar situation to mine. I was told that I posted in a thread and should not ...
0 
