Sheet2 I7:I1006 = formula
Sheet2 H7:H1006 = Where the data will be entered. I want to use multiple entries: "S1" through "S10"
Sheet1 C5:C14 = Exisiting data. Each cell with have a different word in it. "S1" will correspond with with "C5", "S2" with "C6" and so on.
When I enter "S1" into Sheet2 H7, then Sheet2 I7 will show the data existing in Sheet1 C5. and so on
Sheet2 I7:I1006 = formula
Sheet2 H7:H1006 = Where the data will be entered. I want to use multiple entries: "S1" through "S10"
Sheet1 C5:C14 = Exisiting data. Each cell with have a different word in it. "S1" will correspond with with "C5", "S2" with "C6" and so on.
When I enter "S1" into Sheet2 H7, then Sheet2 I7 will show the data existing in Sheet1 C5. and so on
Place this in I7, Copy and Paste down the column
Formula:
Please Login or Register to view this content.
Janos S. Vamos
Data Systems Technician/Fire Controlman PO1(SW/AW)
US Navy Retired
Remember, Record Macro can be your friend for figuring out solutions.
Good or Bad, let me know how I did by clicking on the "Add Reputation" * just to the lower left of here. it only takes a few seconds to let someone know.
The formula provided by vamosj may work but its lengthy
Try this one instead
In Sheet 2 type s1 s2 .....s10 in N7 to N16 and
type c5 c6 .....c14 in O7 to O16
then in I7 type this
=INDIRECT("Sheet1!"&LOOKUP(H7,N7:N16,O7:O16))
I don't know how to attach a file while replying to thread , but i hope u got the idea
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks