How do I lookup and compare cells?
 

I am trying to set a master schedule of my kids schedules.

On the soccer &/or football schedules we have A for away and H for home.

Sheet 1 is the master schedule of all my kids
Sheet 2 has the soccer schedule

I want sheet 1 to look to see if sheet 2 b6 = contains either "A" or "H" or
see if it is blank. If sheet 2 b6 has "A" or "H" inside copy range of cells
to sheet 1.
If sheet 2 b2 is blank - nothing happens

Can I do this?
--
Kelli

How do I lookup and compare cells?
 

Hi Kelli,

One way is to use the following for all the cells you can to show (copy) on
sheet1

for example on sheet1 at the area you want:

=if(or('sheet2'!$b$6="H", 'sheet2'!$b$6="A"), 'sheet2'!c3)

where c3 is the cell to show.
--
Hope this helps
Martin Fishlock, www.nyfconsultants.com, Wolverhampton, UK
Please do not forget to rate this reply.


"Kelli Jordan" wrote:

I am trying to set a master schedule of my kids schedules.

On the soccer &/or football schedules we have A for away and H for home.

Sheet 1 is the master schedule of all my kids
Sheet 2 has the soccer schedule

I want sheet 1 to look to see if sheet 2 b6 = contains either "A" or "H" or
see if it is blank. If sheet 2 b6 has "A" or "H" inside copy range of cells
to sheet 1.
If sheet 2 b2 is blank - nothing happens

Can I do this?
--
Kelli