I'm Trying to Construct a Smart Worksheet
Hi,
Im trying to construct a smart worksheet so when I enter a number or any
value it will automatically give me a specific result if it meets the
requirements from a first worksheet. This is an example of what Im trying to
accomplish, please if anyone can assist I will be very grateful.
Sheet 1 Sheet 2
A A A
1 20 1 704080000112 1
2 30 2 2
3 7 3 3 IF(LEFT(A1,2)=Sheet1!
A1:A5,"CHARD"," ")
Basically I want to use a formula that when the first to digits of a number
is equal to any of the numbers in sheet 1 the result would be any word I want
(example€¯Chard€¯) if not then I want the cell to be blank.
|