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 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" 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" wrote in message news:ce88d3d9-f7fe-4820-96e6-517daf46a435(a)c20g2000prb.googlegroups.com...> On Mar 26, 8:44 am, 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 > > 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