ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF or VLOOKUP (https://www.excelbanter.com/excel-worksheet-functions/260006-if-vlookup.html)

Mark

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

Ziggy

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

Bob Phillips[_4_]

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




Mike H

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


David Biddulph[_2_]

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