I would like to use a formula to reference a cell, which will reference a row in another sheet, then pull data from a cell
So if I type a 3 in sheet 2 in cell A1, it will reference row 3 in sheet 1, if I type a 4 it will reference row 4 in sheet 1, if I type a 5 it will reference row 5 in sheet 1
See excel sheet attached
=INDIRECT("'Sheet1'!A" &$A$1)
Change highlighted for required column
Try in E3 copied down
Modify "50" to conservative estimate of maximum rows.Formula:
Please Login or Register to view this content.
You'll need to format cells returning dates as date.
Does this work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Nothing like missing the obvious!!!
Works great!! Thank you so much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks