Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Return a column # from an array
Hi, I've pulled my hair out trying to nest functions and try various different ways to do this but here's the problem. I have two worksheets. The first sheet, "Rows" has a named range from A2:CV500 'myRng'. All cells within the range are either blank, or hold a unique workorder number anywhere from 4 to 8 digits scattered randomly. The second worksheet "Audit" contains the unique workorder numbers from worksheet "Rows", listed in ascending order in Column A without any spaces. What I need to do is look up the number in column A on my "Audit" Sheet, locate it on the "Rows" sheet and return the column # it was located in. Ex. Audit!A1 = 15899 , Row!C48 = 15899 so Audit!B1 = 3 since "15899" was found in 'C48' on the "Row" worksheet. Any help would be great! Mjack -- mjack003 ------------------------------------------------------------------------ mjack003's Profile: http://www.excelforum.com/member.php...fo&userid=5141 View this thread: http://www.excelforum.com/showthread...hreadid=468422 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return non-zero cells in column | Excel Worksheet Functions |