| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATA FROM ANOTHER WORKSHEET
I have this formula that I am using to pull data data worksheet NSN8. No
problems. =IF(COUNTIF(NSN8!A:A,D1088)=0,"N/A",IF(COUNTIF(NSN8!A:A,D1088),INDEX(NSN8!C:C,MATCH (D1088,NSN8!A:A,0)))) I have created another worksheet NSN09 and started to pull that data in the next row: =IF(COUNTIF(NSN09!A:A,D1089)=0,"N/A",IF(COUNTIF(NSN09!A:A,D1089),INDEX(NSN09!C:C,MAT CH(D1089,NSN09!A:A,0)))) Instead of receiving data from worksheet NSN09, I am getting error #N/A. Why is this? Thanks, Roy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| taking certian data from worksheet one to worksheet 2 | Excel Worksheet Functions | |||
| Using a Worksheet Form to add data to a separate worksheet databas | Excel Worksheet Functions | |||
| Using a column of data from 1 worksheet to extract data from another worksheet | Excel Worksheet Functions | |||
| importing data from Excel worksheet to another worksheet | Excel Worksheet Functions | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
Threaded Mode
