marcdenney1
New Member
- Joined
- Sep 24, 2014
- Messages
- 42
Hi,
I would like a formula to perform a match dependent on the value in the cell.
for example:
if A1 contains "123" match against range A:A in sheet 2
if A1 contains "456" match against range A:A in sheet 3
if A1 contains "789" match against range A:A in sheet 4
i would also like to to return some text depending on the result of the match, which would be different fopr each condition above
e.g. if A1 contains "123" match against range A:A in sheet 2 does not return a match i would like the text"add to sheet2"
is there any easy way to do this?
Thanks
Marc
I would like a formula to perform a match dependent on the value in the cell.
for example:
if A1 contains "123" match against range A:A in sheet 2
if A1 contains "456" match against range A:A in sheet 3
if A1 contains "789" match against range A:A in sheet 4
i would also like to to return some text depending on the result of the match, which would be different fopr each condition above
e.g. if A1 contains "123" match against range A:A in sheet 2 does not return a match i would like the text"add to sheet2"
is there any easy way to do this?
Thanks
Marc