ExcelBanter - Excel 2007 Lookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2007 Lookup (https://www.excelbanter.com/excel-discussion-misc-queries/241201-excel-2007-lookup.html)

Ant

Excel 2007 Lookup

I'm trying to lookup a value in cell Q2 in column P. If found then I want
the cell to indicate that I need to Delete the row, else Keep. How would I
go about doing this?
--
Thank you,
Ant

dhstein

Excel 2007 Lookup

=IF(ISERROR(VLOOKUP(Q2,P:P,1,FALSE),"KEEP","DELETE ")

"Ant" wrote:

I'm trying to lookup a value in cell Q2 in column P. If found then I want
the cell to indicate that I need to Delete the row, else Keep. How would I
go about doing this?
--
Thank you,
Ant

All times are GMT +1. The time now is 03:50 AM.