Field search from another sheet

Daz1975

New Member
Joined
Oct 16, 2006
Messages
2
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
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Daz1975

Welcome to the Mr Excel board!

If the asset is in F28, then in G28 try
=ISNUMBER(MATCH(F28,'Laptop Audit'!B:B,0))
 
Upvote 0

Forum statistics

Threads
1,213,559
Messages
6,114,302
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top