| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP How do I ?
Hi,
I would like to use Vlookup to see if what a user enters in a cell A1 is in a range and if it is not there return 0 in A2 user enters in A1 A2 Scare 0 goes to range called fright in a20 down to a40 and if BOO is not there return 0 in a2 Hope I have made it clear.... Thanks in advance Stephen |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP How do I ?
Sorry forgot this extra bit that if BOO is there it returns a 1
On Feb 5, 3:43 pm, "pano" wrote: Hi, I would like to use Vlookup to see if what a user enters in a cell A1 is in a range and if it is not there return 0 in A2 user enters in A1 A2 Scare 0 goes to range called fright in a20 down to a40 and if BOO is not there return 0 in a2 Hope I have made it clear.... Thanks in advance Stephen |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP How do I ?
Try this:
=(COUNTIF(A20:A40,A1)0)+0 Biff "pano" wrote in message oups.com... Sorry forgot this extra bit that if BOO is there it returns a 1 On Feb 5, 3:43 pm, "pano" wrote: Hi, I would like to use Vlookup to see if what a user enters in a cell A1 is in a range and if it is not there return 0 in A2 user enters in A1 A2 Scare 0 goes to range called fright in a20 down to a40 and if BOO is not there return 0 in a2 Hope I have made it clear.... Thanks in advance Stephen |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP How do I ?
Yes that works, a big thanks.....
On Feb 5, 4:13 pm, "T. Valko" wrote: Try this: =(COUNTIF(A20:A40,A1)0)+0 Biff "pano" wrote in message oups.com... Sorry forgot this extra bit that if BOO is there it returns a 1 On Feb 5, 3:43 pm, "pano" wrote: Hi, I would like to use Vlookup to see if what a user enters in a cell A1 is in a range and if it is not there return 0 in A2 user enters in A1 A2 Scare 0 goes to range called fright in a20 down to a40 and if BOO is not there return 0 in a2 Hope I have made it clear.... Thanks in advance Stephen- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP How do I ?
You're welcome!
Biff "pano" wrote in message oups.com... Yes that works, a big thanks..... On Feb 5, 4:13 pm, "T. Valko" wrote: Try this: =(COUNTIF(A20:A40,A1)0)+0 Biff "pano" wrote in message oups.com... Sorry forgot this extra bit that if BOO is there it returns a 1 On Feb 5, 3:43 pm, "pano" wrote: Hi, I would like to use Vlookup to see if what a user enters in a cell A1 is in a range and if it is not there return 0 in A2 user enters in A1 A2 Scare 0 goes to range called fright in a20 down to a40 and if BOO is not there return 0 in a2 Hope I have made it clear.... Thanks in advance Stephen- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup a Vlookup | Excel Worksheet Functions | |||
| VLOOKUP Problem | Excel Discussion (Misc queries) | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
