Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

MS Excel Vllokup or formula to see if a record exists...

I have two tabs tab1 & tab2, in both tabs column is an ID...

in Tab1 column 2 I want a formula or lookup that simply check all of tab2 column A to see if the ID from column A tab1 exists.

If it exists return yes if it does not return no
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial