Stumped- Possible VLOOKUP Formula?

Lea722

Hello :) I am trying to add a checkmark next to anyone's name who has served as a reviewer when their name appears in the provider being reviewed column. All this info is in the same sheet. Any ideas on a formula?

kowal

ok now it's clear.

have you ever played with VLOOKUP function? if yes I would do this trick.

ok my solution is not the prettiest but it works ;)

=IFERROR(VLOOKUP(Description@row, [Project Name]:Extra, 2, 0), 0)

you need to add extra column which will be full of 1 from top till bottom (you can hide it later) but it will be needed for vlookup function… so whatever will be found will be 1 and if there is no match it will be 0 that's why iferror is used.

not the prettiest solution but it's the first that comes into my head :)

hope it helps

kowal

Hi Lea,

I would love to help you but I do not understand what you want to achieve.

Can you fill some data in those 3 columns to show when the checkmark shall be filled?

Lea722

Thank you for trying to help!

I want a checkmark to automatically show in the "Provider Being Reviewed automatically is Also a Reviewer" column below when a provider being reviewed is also a person reviewing the provider.

Scott Keith and Chris Tobia are examples in the screenshot below. Both of them are someone getting reviewed and they are also reviewers. @kowal

kowal

ok now it's clear.

have you ever played with VLOOKUP function? if yes I would do this trick.

ok my solution is not the prettiest but it works ;)

=IFERROR(VLOOKUP(Description@row, [Project Name]:Extra, 2, 0), 0)

you need to add extra column which will be full of 1 from top till bottom (you can hide it later) but it will be needed for vlookup function… so whatever will be found will be 1 and if there is no match it will be 0 that's why iferror is used.

not the prettiest solution but it's the first that comes into my head :)

hope it helps

Lea722

This helped me get to a solution. Thank you @kowal!!

kowal

Happy to help! :)