Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v look up and if statement
I need a formula that will lok up what is in a cell an another worksheet, and
return "y" if it finds it and "n" if it doesn't I've tried using an if ststement with a v look up but I can't seem to get it right |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v look up and if statement
=IF(ISNA(VLOOKUP(B1,Sheet2!A1:A4,1,FALSE)),"n","y" )
-- Kind regards, Niek Otten Microsoft MVP - Excel "Katie" wrote in message ... |I need a formula that will lok up what is in a cell an another worksheet, and | return "y" if it finds it and "n" if it doesn't | | I've tried using an if ststement with a v look up but I can't seem to get it | right |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v look up and if statement
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v look up and if statement
=IF(ISERROR(VLOOKUP([your vlookup])),"n","y")
Dave -- Brevity is the soul of wit. "Katie" wrote: I need a formula that will lok up what is in a cell an another worksheet, and return "y" if it finds it and "n" if it doesn't I've tried using an if ststement with a v look up but I can't seem to get it right |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
v look up and if statement
See also responses to your earlier identical posting ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Katie" wrote in message ... I need a formula that will lok up what is in a cell an another worksheet, and return "y" if it finds it and "n" if it doesn't I've tried using an if ststement with a v look up but I can't seem to get it right |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question using dates in a statement | Excel Discussion (Misc queries) | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions |