IF or VLOOKUP

M

Mark

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
 
Z

Ziggy

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
 
B

Bob Phillips

Sounds like you want

=VLOOKUP(value,all_columns_looking_at,offset_from_first_column,2)
 
M

Mike H

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top