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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,493
Office Version
  1. 365
Platform
  1. Windows
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))
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
49,493
Office Version
  1. 365
Platform
  1. Windows
cheers Peter

Works great, no more banging my head on this keyboard
No, but you could always try this: :oops:
 

Forum statistics

Threads
1,136,990
Messages
5,678,985
Members
419,797
Latest member
ikethegenius

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
Top