Forum Discussion
Solved
Formula for Cross-checking names on sheet 2 column A against sheet 1 cells B2:N4
Hi guys Can you help me with the above please? I’m a complete newbie and have tried a few searches on here to try to help me but it’s completely beyond my sphere of knowledge. Thanks in advan...
Bmurphy76 Please see if you can get to grips with the formulae in the attached workbook, where I tried to replicate what you described.
Thanks Riny,
I have a list of names from an organisation on sheet 2 column A and I have hotel rooms allocated to the names on sheet 1 across cells B2:N4. So I'm looking for a formula to search for their names and to give me a 'true' or 'yes' value if they've been included in the hotel room allocation to make sure I haven't missed anybody.
Bmurphy76 Please see if you can get to grips with the formulae in the attached workbook, where I tried to replicate what you described.
- Thanks a million for your help.
Although I couldn't copy the formula over to my file, instead I copied my data into your file and got the desired results. Many thanks for your help.