Looking for entries and copying to a cell

B

Budask

If cell value in B2 is shown anywhere in column A, how can I show that
cell value in C2?

I have got as far as having the following in cell C2 =IF((B2=A2),B2)
which works but only if the cell being looked for is in A2. When I try
to extend the look up to the whole of column A (say A2:A100) so that
can look in anywhere within that column, it no longer works.

Not sure if the is an "If", "lookup" or some other function - thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Column and cell identificatiion 3
Copying formulas across columns 2
Copy Data from One Spreadsheet to Another ?????? 5
I need to evalute two cells and return a result 1
Help needed for Excel formula using if, iserr, match and vlookup! 1
use cell text in lookup function 3
Change formulas in a column based on a selection. 3
Write formula for simple copy and paste to another cell 1

Top