| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stumped
I want column W9 of sheet 2 to say NEW if G9 on sheet 2 appears in cells
B2:B50 (exact match, not partial) on sheet 1. Help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stumped
=IF(ISNA(VLOOKUP(G9,sheet1!B2:B50)),"","NEW")
Will leave blank if not an exact match. "lightbulb" wrote: I want column W9 of sheet 2 to say NEW if G9 on sheet 2 appears in cells B2:B50 (exact match, not partial) on sheet 1. Help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stumped
Hi,
See your other post "lightbulb" wrote: I want column W9 of sheet 2 to say NEW if G9 on sheet 2 appears in cells B2:B50 (exact match, not partial) on sheet 1. Help? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stumped
Vlookup requires 3 arguments and you only have 2 so it will not allow you to
enter it. Additioanlly you have missed the optional 4th argument which means that it is doing a sorted lookup which may not find the value. Match would be a better choice for what you are doing instead of Vlookup. =IF(ISNA(MATCH(G9,Sheet1!B2:B50, 0)),"","NEW") -- HTH... Jim Thomlinson "Sean Timmons" wrote: =IF(ISNA(VLOOKUP(G9,sheet1!B2:B50)),"","NEW") Will leave blank if not an exact match. "lightbulb" wrote: I want column W9 of sheet 2 to say NEW if G9 on sheet 2 appears in cells B2:B50 (exact match, not partial) on sheet 1. Help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| STUMPED | Excel Worksheet Functions | |||
| Stumped | Excel Discussion (Misc queries) | |||
| I'm stumped | Excel Discussion (Misc queries) | |||
| I'm Stumped | Excel Discussion (Misc queries) | |||
| Still stumped | Excel Worksheet Functions | |||
Linear Mode
