Hi, I have a table/grid 500 rows down by 75 columns on a sheet.
Column 1 contains a string (not unique) for each row.
Columns 2 - 75 each contain a unique value. (M1, M2, etc).
On several other sheets I have a section of data that I need to get the values/contents of the cell from the first mentioned sheet into specific cells.
e.g. Cell A1 = the unique value (M1, M2, etc).
For Cells B5, B10, B15, B20, etc, I need to find an exact match for cells C5, C10, C15, C20, etc, from the appropriate column on the first sheet where the number in cell A1 matches the column number.
I have tried using variations on the following formula
=IF($A$1="M73",VLOOKUP(C5,Look!$A$3:$BU$1961,73,FALSE)," ")
but because the first column is not unique then I get blanks in my data.
What I want to be able to do is use a search that will allow duplicates for the non unique string and return the corresponding value in the column where the unique column value equals the cell A! of the sheet I am trying to complete.
Any Thoughts?
Column 1 contains a string (not unique) for each row.
Columns 2 - 75 each contain a unique value. (M1, M2, etc).
On several other sheets I have a section of data that I need to get the values/contents of the cell from the first mentioned sheet into specific cells.
e.g. Cell A1 = the unique value (M1, M2, etc).
For Cells B5, B10, B15, B20, etc, I need to find an exact match for cells C5, C10, C15, C20, etc, from the appropriate column on the first sheet where the number in cell A1 matches the column number.
I have tried using variations on the following formula
=IF($A$1="M73",VLOOKUP(C5,Look!$A$3:$BU$1961,73,FALSE)," ")
but because the first column is not unique then I get blanks in my data.
What I want to be able to do is use a search that will allow duplicates for the non unique string and return the corresponding value in the column where the unique column value equals the cell A! of the sheet I am trying to complete.
Any Thoughts?