Forum Discussion

Copper Contributor

Apr 01, 2018

Solved

Excel search

My excel spreadsheet has ~50000 rows of names and ~25 columns of relevant information. I would like to search, find and highlight ~2000 (of the 50000) names and relevant column information. ...

Formulas & Functions

tips and tricks

IngeborgHawighorst
Apr 01, 2018
Hello,

in the following screenshot, I moved the list to column F and created a helper column in column D with the formula

=IF(COUNTIF(F:F,A2)>0,TRUE,FALSE)

in cell D2 and copied down.

Then I selected the whole table from row 2 to the bottom and created a new conditional formatting rule with the formula

=$D2

I selected a yellow fill and confirmed all dialogs.

Vivek Mahadevan

Copper Contributor

Apr 01, 2018

Hi Haytham,

Thanks for your response!

Please see the attached excel.

I have abridged my table here with ~1000 rows and 3 columns.

I need to find the 20 IDs highlighted in column 4 from column1.

How to use the index/match/vlookup in this case?

Excel example.xlsx55 KB

IngeborgHawighorst

MVP

Apr 01, 2018

Hello,

in the following screenshot, I moved the list to column F and created a helper column in column D with the formula

=IF(COUNTIF(F:F,A2)>0,TRUE,FALSE)

in cell D2 and copied down.

Then I selected the whole table from row 2 to the bottom and created a new conditional formatting rule with the formula

=$D2

I selected a yellow fill and confirmed all dialogs.

Vivek Mahadevan
Copper Contributor
Apr 02, 2018
Hi Ingeborg Hawighorst,

Worked really well!!!

Thanks for saving my weekend, and a lot of time!!!

Best regards,

Viv