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


Hello,

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...