Help!!!!
I have 2 sheets (sheet 1 is called Laptop Audit, sheet two is called building A) in one sheet there are a number of columns but the column I am dealing with is B, in this column there are a list of assets from B2 to B113 the assets are all named as follows
ABCD001901D
ABCD001902D
ABCD001903L
ABCD001907D
D being Desktop
L being Laptop
I am then using sheet 2 to check for these assets around the building if I find the asset I put it in a another column next to the persons name, so in this case sheet two row F contains different assets. Does this make sense?
OK now down to the problem as I am typing in the asset number on sheet two I want the cell next to it to do a search of sheet 1 column B to see if it exists already exists, if it does to then mark the cell as TRUE the sum I am currently using is
=IF(F28='Laptop Audit'!B2:B113,TRUE,FALSE) the result is always coming back as False.
If I replace the B2:B113 with the cell that I know contacts the correct asset then I get a TRUE result
=IF(F28='Laptop Audit'!B18,TRUE,FALSE)
Does anyone know how I can get this to search correctly?
Thanks in advance
Darren
I have 2 sheets (sheet 1 is called Laptop Audit, sheet two is called building A) in one sheet there are a number of columns but the column I am dealing with is B, in this column there are a list of assets from B2 to B113 the assets are all named as follows
ABCD001901D
ABCD001902D
ABCD001903L
ABCD001907D
D being Desktop
L being Laptop
I am then using sheet 2 to check for these assets around the building if I find the asset I put it in a another column next to the persons name, so in this case sheet two row F contains different assets. Does this make sense?
OK now down to the problem as I am typing in the asset number on sheet two I want the cell next to it to do a search of sheet 1 column B to see if it exists already exists, if it does to then mark the cell as TRUE the sum I am currently using is
=IF(F28='Laptop Audit'!B2:B113,TRUE,FALSE) the result is always coming back as False.
If I replace the B2:B113 with the cell that I know contacts the correct asset then I get a TRUE result
=IF(F28='Laptop Audit'!B18,TRUE,FALSE)
Does anyone know how I can get this to search correctly?
Thanks in advance
Darren