IF or VLOOKUP
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 |
IF or VLOOKUP
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 |
IF or VLOOKUP
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 |
IF or VLOOKUP
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 |
IF or VLOOKUP
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 |
All times are GMT +1. The time now is 10:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com