| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Vlookup as "value_if_true" in IF function
I wonder if it is possible? =IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-") I can confirm that my vlookup function and logical test is correct. Or is there a problem with the absolute cell reference that i used? -- dark_snowboy ------------------------------------------------------------------------ dark_snowboy's Profile: http://www.excelforum.com/member.php...o&userid=30466 View this thread: http://www.excelforum.com/showthread...hreadid=505236 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup as "value_if_true" in IF function
i dont think F12=F3:F8 is quite correct(or is this where you need ctrl shift
enter????) ,and the lookup function doesnt need to be in quotes =IF(F12=(F3:F8),=VLOOKUP($F$12,$F$3:$L$8,7,FALSE), "-"),or is this where you need ctrl shift enter???? So if the logical test is true you get the lookup otherwise - -- paul remove nospam for email addy! "dark_snowboy" wrote: I wonder if it is possible? =IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-") I can confirm that my vlookup function and logical test is correct. Or is there a problem with the absolute cell reference that i used? -- dark_snowboy ------------------------------------------------------------------------ dark_snowboy's Profile: http://www.excelforum.com/member.php...o&userid=30466 View this thread: http://www.excelforum.com/showthread...hreadid=505236 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup as "value_if_true" in IF function
Hi!
=IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-") F12=F3:F8 This is an array and in order for it to evaluate as TRUE, you'd have to enter the formula as an array and every cell in the array, F3:F8, would have to equal F12. Maybe you want something like this: =IF(COUNTIF(F3:F8,F12),VLOOKUP(F12,F3:L8,7,0),"-") Biff "dark_snowboy" wrote in message news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com... I wonder if it is possible? =IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-") I can confirm that my vlookup function and logical test is correct. Or is there a problem with the absolute cell reference that i used? -- dark_snowboy ------------------------------------------------------------------------ dark_snowboy's Profile: http://www.excelforum.com/member.php...o&userid=30466 View this thread: http://www.excelforum.com/showthread...hreadid=505236 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup as "value_if_true" in IF function
Biff(not wanting to hijack thread) if i enter {=f12=f3:f8} with ctrl shift
enter it behaves exactly as you say,but {=f3:f8=f12} with ctrl shift enter doesnt it only seems to evaluate f3...... -- paul remove nospam for email addy! "Biff" wrote: Hi! =IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-") F12=F3:F8 This is an array and in order for it to evaluate as TRUE, you'd have to enter the formula as an array and every cell in the array, F3:F8, would have to equal F12. Maybe you want something like this: =IF(COUNTIF(F3:F8,F12),VLOOKUP(F12,F3:L8,7,0),"-") Biff "dark_snowboy" wrote in message news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com... I wonder if it is possible? =IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-") I can confirm that my vlookup function and logical test is correct. Or is there a problem with the absolute cell reference that i used? -- dark_snowboy ------------------------------------------------------------------------ dark_snowboy's Profile: http://www.excelforum.com/member.php...o&userid=30466 View this thread: http://www.excelforum.com/showthread...hreadid=505236 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using Vlookup as "value_if_true" in IF function
Hi
It looks like this will do =IF(ISNA(VLOOKUP($F$12,$F$3:$L$8,7,0)),"-",VLOOKUP($F$12,$F$3:$L$8,7,0)) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "dark_snowboy" wrote in message news:dark_snowboy.228chy_1138258800.9796@excelforu m-nospam.com... I wonder if it is possible? =IF(F12=F3:F8,"=VLOOKUP($F$12,$F$3:$L$8,7,FALSE)", "-") I can confirm that my vlookup function and logical test is correct. Or is there a problem with the absolute cell reference that i used? -- dark_snowboy ------------------------------------------------------------------------ dark_snowboy's Profile: http://www.excelforum.com/member.php...o&userid=30466 View this thread: http://www.excelforum.com/showthread...hreadid=505236 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup worksheet function | Excel Worksheet Functions | |||
| Vlookup with function in table_array | Excel Worksheet Functions | |||
| format cell based on results of vlookup function | Excel Worksheet Functions | |||
| Vlookup w/Date Function | Excel Worksheet Functions | |||
| Regarding IF function or vLOOKUP function | Excel Worksheet Functions | |||
Linear Mode
