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

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

Sounds like you want

=VLOOKUP(value,all_columns_looking_at,offset_from_ first_column,2)

--

HTH

Bob

"Mark" wrote in message
...
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

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

Or just =A1=D1
--
David Biddulph


"Ziggy" wrote in message
...
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