IF or VLOOKUP

  • Thread starter Thread starter Mark
  • Start date Start date
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
 
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
Click to expand...

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)
 
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.
 
Back
Top