Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP used only when IF condition is met
I am trying to write and IF statement with a VLOOKUP. I only want the value
to be returned when the IF column is equal to a set value. For example, I have a data worksheet which has months and document #'s and total hits. I am creating another worksheet that wil search the data page and return the number of hits for the document, but I want to be able to compile by month. So when month is equal to 200501 I want the value for the contract to be returned. This is what I have written: =IF(('DOC TOTALS'!C1=200501),VLOOKUP(E2,'DOC TOTALS'!A:C,2,FALSE),0) But this only will search the C1 row to see if it is =200501, I want the whole column to be searched. Thank you Bradley |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP used only when IF condition is met
Why not try a SUMIF function or COUNTIF function.
"Bradley" wrote: I am trying to write and IF statement with a VLOOKUP. I only want the value to be returned when the IF column is equal to a set value. For example, I have a data worksheet which has months and document #'s and total hits. I am creating another worksheet that wil search the data page and return the number of hits for the document, but I want to be able to compile by month. So when month is equal to 200501 I want the value for the contract to be returned. This is what I have written: =IF(('DOC TOTALS'!C1=200501),VLOOKUP(E2,'DOC TOTALS'!A:C,2,FALSE),0) But this only will search the C1 row to see if it is =200501, I want the whole column to be searched. Thank you Bradley |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP used only when IF condition is met
Hi Bradley
Try =IF(COUNTIF('DOC TOTALS'!C:C,"=200501")0,VLOOKUP(E2,'DOC TOTALS'!A:C,2,FALSE),0) Regards Roger Govier Bradley wrote: I am trying to write and IF statement with a VLOOKUP. I only want the value to be returned when the IF column is equal to a set value. For example, I have a data worksheet which has months and document #'s and total hits. I am creating another worksheet that wil search the data page and return the number of hits for the document, but I want to be able to compile by month. So when month is equal to 200501 I want the value for the contract to be returned. This is what I have written: =IF(('DOC TOTALS'!C1=200501),VLOOKUP(E2,'DOC TOTALS'!A:C,2,FALSE),0) But this only will search the C1 row to see if it is =200501, I want the whole column to be searched. Thank you Bradley |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP used only when IF condition is met
On Tue, 22 Nov 2005 08:59:07 -0800, "Bradley"
wrote: I am trying to write and IF statement with a VLOOKUP. I only want the value to be returned when the IF column is equal to a set value. For example, I have a data worksheet which has months and document #'s and total hits. I am creating another worksheet that wil search the data page and return the number of hits for the document, but I want to be able to compile by month. So when month is equal to 200501 I want the value for the contract to be returned. This is what I have written: =IF(('DOC TOTALS'!C1=200501),VLOOKUP(E2,'DOC TOTALS'!A:C,2,FALSE),0) But this only will search the C1 row to see if it is =200501, I want the whole column to be searched. Thank you Bradley =IF(MATCH(200501,'DOC TOTALS'!C:C),VLOOKUP(E2,'DOC TOTALS'!A:C,2,FALSE),0) HTH Richard Buttrey __ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
Vlookup using a range condition | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
vlookup in two condition | Excel Discussion (Misc queries) | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |