MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need a formula to find something in one cell and put it in another cell.


Posted by Al on December 04, 2001 2:35 PM

I have a table in A300:A393. What I need is If Col A300:A393 contains an entry equal to A3 then print the value of the cell (C300) in C3 or if C300 has nothing in it print 0 in C3, then what is in D300 in D3 ETC all the way to AG3. And the same will apply to A4 thru AG250.


Posted by jacob on December 04, 2001 11:21 PM

Maybe this will help
in C3 put this:

=If((or(C300="",C300=0)),"",if(ISNA(VLOOKUP(A3,$A$300:$A$G393,3,FALSE),"",VLOOKUP(A3,$A$300:$A$G393,3,FALSE))

Then fill the equations to all the rows and columns you need. Change the 3 in the vlookup part to the column that has the value you want returned for each field.

Hope this helps

Posted by Al on December 05, 2001 2:13 PM

When I use this formula it says this formula contains an error and has one section blacked out as in the following the first$A$G393 is what is blacked out. Any answer for this?

Posted by Al on December 05, 2001 3:12 PM

If it would be of any help I could E-Mail you a short version of my spreadsheet.