IF or VLOOKUP
in [Functions]
|
From: Mark on 26 Mar 2010 10:44 Trying to look at value in one cell(column), then see if a value in another cell in the same row equals a specific value, then return True or False
From: Ziggy on 26 Mar 2010 10:49 On Mar 26, 8:44 am, Mark <M...(a)discussions.microsoft.com> wrote: > Trying to look at value in one cell(column), then see if a value in another > cell in the same row equals a specific value, then return True or False I'd use an IF statement =IF(A1=D1,"True","False") or other results as needed
From: Bob Phillips on 26 Mar 2010 10:51 Sounds like you want =VLOOKUP(value,all_columns_looking_at,offset_from_first_column,2) -- HTH Bob "Mark" <Mark(a)discussions.microsoft.com> wrote in message news:3C59B84A-58E1-4F7A-B8D9-F878DAA0DB15(a)microsoft.com... > Trying to look at value in one cell(column), then see if a value in > another > cell in the same row equals a specific value, then return True or False
From: Mike H on 26 Mar 2010 10:53 Mark, You may not need either of those, perhaps this =A4=F4 -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Mark" wrote: > Trying to look at value in one cell(column), then see if a value in another > cell in the same row equals a specific value, then return True or False
From: "David Biddulph" groups [at] on 26 Mar 2010 12:29 Or just =A1=D1 -- David Biddulph "Ziggy" <ziggy943(a)xmission.com> wrote in message news:ce88d3d9-f7fe-4820-96e6-517daf46a435(a)c20g2000prb.googlegroups.com... > On Mar 26, 8:44 am, Mark <M...(a)discussions.microsoft.com> wrote: >> Trying to look at value in one cell(column), then see if a value in >> another >> cell in the same row equals a specific value, then return True or False > > I'd use an IF statement > > =IF(A1=D1,"True","False") or other results as needed
|
Pages: 1 Prev: How to carry Excel balance on 1 w/s to another? Next: Toolbar question |