| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Address - Row No.
Hi,
In Sheet 1, I have this Data, Column 1 Row 1 Data 1 Row 2 Row 3 Data 2 Row 4 Row 5 Row 6 Row 7 Data 3 Row 8 Data 4 Row 9 Data 5 Row 10 Row 11 Data 6 In Sheet 2 Column 1 Result Row 1 Data 1 1 Row 2 Data 2 3 Row 3 Data 3 7 Row 4 Data 4 8 Row 5 Data 5 9 Row 6 Data 6 6 My aim is to get the Row Number in Sheet 1 if the Data in Sheet 2 is matching with Sheet 1. Let say, if I type "Data 1" in cell A1 the result in B1 should be "1". If Data 2, result must be "3", and soon. Thanks for the help. EricBB |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| European Address Data | Excel Discussion (Misc queries) | |||
| How do I avoid excel change absolute address to relative address | Excel Discussion (Misc queries) | |||
| How do I separate data in address field? | New Users to Excel | |||
| long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
| How do I import Office address book to Outlook Express address bo. | Excel Discussion (Misc queries) | |||
Threaded Mode
