Need formula to check adjacent cell value, and report.

Ok. I am creating item lists in excel for every product that my company sells. I am in need of a formula that does the following:

I want the cell to check to see if there is a value in another cell, and if there is anything at all, i want to display the word Yes as the value, or leave the cell empty.

So I want the cells in Column A to Check if the adjacent cells in Column B have a value. If the column b cells have a value I want the cells in Column A to display the word "Inventory Part". If there is no value I want the cell left blank.

Can anyone help?

Try, in A2

=IF(B2="","","Inventory Part")

copied down

Here are a couple options.....

Please Login or Register  to view this content.

Does that help?

copy the formula down.

Select A2, click and hold the little black square at the bottom right corner of the cell and drag it down the column.

Yes....
Here are 2 ways:

• Select A2
• Click-and-hold on the fill handle (in the lower right corner of the cell)
(The cursor will turn into a cross)
• Drag the formula down as far as you need...then release the mouse button


or..
• Select A2
• From the Excel Main Menu: <edit><copy>
• Select from A2 down as far as you need
• Press ENTER

Does that help?
(Post back with more questions)

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save