| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
very urgent : to write the value of next column of the same row
I applied the following formula to find the matching and write the data of
the corresponding next cell. Sheet1. the column C:C has custom format 000-000 having the data like this 123-456 12 001-789 11 313-245 13 456-779 16 084-321 18 IF(ISNA(MATCH(D5,Sheet1!C:C,0)),"Not exist",Sheet1!D2). the matching is working but after, it is not writing corresponding data from D2 value. It will put the data from skipping two row. Please help Active sheet The column B1 has the following data ABC123456 DSD001789 HGH084321 YYY343434 like this 7500 record exist. With thanks Pol |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Column headings - urgent help needed please | Excel Discussion (Misc queries) | |||
| Formula to write Calendar dates excluding weekends - urgent pleas | Excel Discussion (Misc queries) | |||
| *** Urgent help formula * Need to sum values in a column if all .. | Excel Worksheet Functions | |||
| find a specific value in a column and write another column | Excel Discussion (Misc queries) | |||
| Urgent Problem with Number Column | New Users to Excel | |||
Threaded Mode
