How do I use lookup for this case ?
I have an excel file with 5 different sheets. I want to check sheets 1..4
against there is a match for my data in sheet 5. How do I do this ? What
happens if there are multiple matches ? How do I avoid this multiple match
problem ?
|