Hi all,
So I need help writing a formula, not in vba, that looks at a number in column A, then looks at another sheet. Finds the value from column A in a list. If a value isn't found, it returns "Check". For example:
<tbody>
</tbody>
<tbody>
</tbody>
So using the tables as an example, I need a formula in sheet 1 Column B that will look at column A, find "Dog" on sheet 2. If Dog has "nothing", in column B, then retutrn the value "check".
If that doesn't make sense I can try and describe it.
So I need help writing a formula, not in vba, that looks at a number in column A, then looks at another sheet. Finds the value from column A in a list. If a value isn't found, it returns "Check". For example:
Sheet 1 | A | B | C |
1 | Dog | ||
2 | Cat | ||
3 | Frog |
<tbody>
</tbody>
Sheet 2 | A | B | C |
1 | Dog | Food | |
2 | Cat | Water | |
3 | Dog | Nothing |
<tbody>
</tbody>
So using the tables as an example, I need a formula in sheet 1 Column B that will look at column A, find "Dog" on sheet 2. If Dog has "nothing", in column B, then retutrn the value "check".
If that doesn't make sense I can try and describe it.