| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
The formula works if I copy from Auckland Kilometres
Hello from Steved
If I copy from Auckland Kilometres spreadsheet and "paste" or "value" to the worksheet with the below formula it is fine, I've tried to put --B22 believeing it to be text but also it does not work. What is required please. {=IF(ISNA(VLOOKUP(B22,'Auckland Kilometres'!$A$5:$E$5007,2,FALSE)),"Out Of Service",VLOOKUP(B22,'Auckland Kilometres'!$A$5:$E$5007,2,FALSE))} I Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy a formula to the right increasing the rows from another works | Excel Worksheet Functions | |||
| HELP! Copy/Paste Macro Works on PC But Not Mac! | Excel Discussion (Misc queries) | |||
| How do I prevent copy and pasting into a selected range of a works | Excel Discussion (Misc queries) | |||
| Works if I copy F Col to A Col | Excel Worksheet Functions | |||
| Kilometres Calculator | Excel Worksheet Functions | |||
Threaded Mode
