MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Fromula to find something in one cell and put it in another cell.

Posted by Al on December 04, 2001 2:20 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 Bib on December 05, 2001 4:10 AM


Your problem can typically be solved with the VLOOKUP function and dynamic generated ranges...
Have a look at the help for VLOOKUP and see if you can reorganise your A300:A393 range...