Home |
Search |
Today's Posts |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Row??
Try this:
=INDIRECT("B"&A1) Hope this helps. Pete "j.ruderman" wrote in message ... I have a Row# listed in a cell and a known column. How can I combine the two? A1 contains the row# with B being the known column. Result of the formula woulld be 10 a b c 1 4 2 3 4 10 5 Hope this make sense. Thanks |